Start at the end?

[Sue]

I have an "ADD FIELD" button on my main contacts form that allows me to add
"New City", another "ADD FIELD" button to add "New Zip", etc. When I click
the button, the appropriate form opens, but it doesn't open with a blank
field for adding the new piece of data. Instead, it opens for, say
"Albiquerque" under "add city". I have to click the >* button to get to the
end of the list in order to add a new city. Can I eliminate the >* step & go
straight to the blank field to enter data?

 

[fredg]

I have an "ADD FIELD" button on my main contacts form that allows me to add
"New City", another "ADD FIELD" button to add "New Zip", etc. When I click
the button, the appropriate form opens, but it doesn't open with a blank
field for adding the new piece of data. Instead, it opens for, say
"Albiquerque" under "add city". I have to click the >* button to get to the
end of the list in order to add a new city. Can I eliminate the >* step & go
straight to the blank field to enter data?

One of the arguments in the OpenForm method is to open the form for a
new record entry. Use it.
DoCmd.OpenForm "FormName", , , , acFormAdd