Feb 11 2008, 05:30 PM
the database opens to a switchboard, on the switchboard I'll choose the FORM, when the form opens, its at the very first record entered. How can I have the foem open to the empty/not filled in record?
Feb 11 2008, 05:45 PM
If you want to still be able to get to all the existing data, then in the OnOpen event you need a:
DoCmd.GoToRecord , , acNewRec
If you only want to see the new record, you need to set the DataEntry property of the form to Yes.
P.S. Welcome to UA Forums!
Feb 11 2008, 05:52 PM
If you want to still be able to get to all the existing data.......YES
then in the OnOpen event you need a DoCmd.GoToRecord,,acNewRec........GREAT!
Now where to I put this code? On the switchboard? On the form inself?
I am sorry but you will have to be more specific, REAL SPECIFIC !
Thanks for the welcome, its great to find someone who can and is willing to help
Feb 11 2008, 06:01 PM
In form design look at the properties for the form itself. Find the one that says OnOpen and click the elipsis (...) at the end of the line. This should take you to the VBA editor. Paste in the line of code in between the event it just created.
Feb 11 2008, 09:28 PM
AWSOME !! so far so good, seems to work ok
excuse my scepticism, but have created things that work the first time but never again
thank you for your time and help
by n by, would you happen to know how to.......
I have two forms, I placed a command button on form #1 to open form #2 when needed
(not every record requires the extentions on form2)
So when need be, I click on this button in form1 and open form2. When I finish in form2, I created another button to "close" this form and form1 is now available again EXCEPT I now have to get the mouse and click in the next field to continue filling in data on form1. What I would like is to click the close button in form2 and the cursor automatly moves to the next field after the button in form1 (the button is 2/3 into the record) so there is more data to put in after I make this form jump.
The field name in form1 that I would want the cursor to go to is called PEDESTRIANS
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here