List Items Edit Form

[Joel Parker]

I have a form with a combo box control in which I allow edits to the list
items by specifying a List Items Edit Form.

When I actually invoke this edit form (through the "edit" button that
shows up whenever I open the combo box list), it points me directly at the
first existing record in the form. I'm afraid this is going to cause
people to overwrite this first record without thinking about it, so I
would like it to open with a new record, but still allow people to go back
to an existing one if they need to make a change.

In sum, when a user invokes the List Items Edit Form through a combo box
or list control, I would like it to come up to a new record, not existing
record #1.

Any advice?

Thanks,
Joel

 

[Guest]

You probably open your edit form with something like:

DoCmd.OpenForm "formname"

If you change this to
DoCmd.OpenForm "formname", , , , acFormAdd
it should go to a new record and still have the ability to go to previous
records.

hth

 

[Joel Parker]

I'm opening my edit form by specifying a form name for the
ListItemsEditForm property of the combo box.

Something like:

field.ListItemsEditForm = "Form1"

Thanks,
Joel