PDA

View Full Version : Solved: new entry when opened



RonNCmale
05-01-2008, 09:13 PM
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.

OBP
05-02-2008, 04:12 AM
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.

CreganTur
05-02-2008, 05:44 AM
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.

RonNCmale
05-05-2008, 08:09 PM
I worked, thanks for the input.