How can I get a form to open when the database opens?
J jamphan Registered User. Local time Yesterday, 16:39 Joined Dec 28, 2004 Messages 143 Aug 16, 2007 #1 How can I get a form to open when the database opens?
pbaldy Wino Moderator Staff member Local time Yesterday, 16:39 Joined Aug 30, 2003 Messages 36,133 Aug 16, 2007 #2 Tools/Startup
J jamphan Registered User. Local time Yesterday, 16:39 Joined Dec 28, 2004 Messages 143 Aug 16, 2007 #3 thanks! How about getting it to advance to a new record when it opens?
pbaldy Wino Moderator Staff member Local time Yesterday, 16:39 Joined Aug 30, 2003 Messages 36,133 Aug 16, 2007 #4 One way would be to set the form's Data Entry property to Yes.
J jamphan Registered User. Local time Yesterday, 16:39 Joined Dec 28, 2004 Messages 143 Aug 16, 2007 #5 I want the other records to be able to be accessed though. That seems to erase all the other records from the form.
I want the other records to be able to be accessed though. That seems to erase all the other records from the form.
pbaldy Wino Moderator Staff member Local time Yesterday, 16:39 Joined Aug 30, 2003 Messages 36,133 Aug 16, 2007 #6 It doesn't erase anything, they just aren't being viewed. Change that setting back and put this in the load event of the form: DoCmd.GoToRecord , , acNewRec
It doesn't erase anything, they just aren't being viewed. Change that setting back and put this in the load event of the form: DoCmd.GoToRecord , , acNewRec