In access 2003 is there a way to have the form set to a new entry. I have to hit the > key to go to a new entry page.
In access 2003 is there a way to have the form set to a new entry. I have to hit the > key to go to a new entry page.
If you use a Command Button to open the form have a look at the Docmd statement.
On the end of it type a , (comma) and it will give you a list of options, if "acFormAdd" is not there type another comma until it is in the list and then select it.
There are normally 4 commas after the Form's name to get this form control, so you could try typing that in, but not if you have "criteria" set.
If you want to go to a new entry so that your users can enter data, then there's a property you can set.
Go to your form in design view and look at your properties sheet. Go to the Data tab, look for Data Entry, and change it to "Yes". This will make your form so that only new records can be added.
-Randy Shea
I'm a programmer, but I'm also pro-grammar!
If your issue is resolved, please use Thread Tools to mark your thread as Solved!
PODA (Professional Office Developers Association) | Certifiable | MOS: Access 2003
I worked, thanks for the input.