 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / February 2005Detecting a new record on a subform
I need to change which controls are displayed if the user is on a new record. I'm trying to use the isNewRecord() function to handle this, however the function is not detecting that the user has moved to a new record when I click on the NEW RECORD navigation button. As you can guess, I'm trying to detect when a new record has been added to a subform/when the subform has moved to a new record. David H You need code in the Form_Current event for the subform, i.e., If Me.NewRecord then 'Hide controls Else 'Unhide controls End if You also need to call Form_Current from Form_Afterupdate (so the controls will be shown after record is added). One post on a given topic is sufficient. Multiple posts aren't going to help any unless you are clarifying something, in which case you should post under the same thread.  SignaturePaul Overway Logico Solutions http://www.logico-solutions.com >I need to change which controls are displayed if the user is on a new >record. I'm trying to use the isNewRecord() function to handle this, [quoted text clipped - 5 lines] > > David H Did I post multiple times? > You need code in the Form_Current event for the subform, i.e., > [quoted text clipped - 10 lines] > help any unless you are clarifying something, in which case you should post > under the same thread. Sorry about the double posting. I posted the first message and then realized that I could state the problem a bit easier and forgot to cancel the first. > You need code in the Form_Current event for the subform, i.e., > [quoted text clipped - 10 lines] > help any unless you are clarifying something, in which case you should post > under the same thread. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.