The list items edit form should be used only for that purpose.
Why not just make a separate form, just to add new records. Or you can copy
the form you are using, name it differently, and reuse it. Then you can use
it's property sheet in design view to make it an add only form; if I recall,
the property name is DataEntry only, or something like that.
This way you won't need any VBA. (I think! I haven't tried this yet in 2007.)
--
Frank H
Rockford, IL
j_gold said:
Sorry, should have clarified. The form that the combo box uses is also used
separately so that the user can scroll through and make changes to the
entries. If I set the forms data entry property to yes I cannot view all
records. If I use the OnOpen Event then I am always taken to a new record.
What I want is to have it go to a new record only if the combobox has called
the form.
J
S.Clark said:
Either:
1. Set the Form's [Data Entry] property to Yes.
2. Enter this code into the OnOpen Event of the Form
DoCmd.GotoRecord acNewRec
:
Hi, I have a combo box control which allows edits to the list items by
specifying a List Items Edit Form.
When I go to add an entry through the "edit" button that
appears when I click on the combobox it goes to the first record of the form
used to edit. I want users to be taken to a blank form and not see any other
records. Is this possible?
Thanks,
J Gold