Adding a Record?????

[Jens]

I have set up a basic database that will be used to store
information specific to an item. The form has a combo box
that has the item numbers in it to choose from, and the
rest of the fields are text boxes that are controlled by
the combo box. The problem I am having is I put a button
on the form and ran the wizard to make it a button to add
a new record. When I click on the button, it blanks out
all of the fields (which is right), I then proceed to
enter an item number first, then when I go to the next
field (text box), everything resets and it goes back to
the first record. Is this caused by the after update
event on the cobo box? How can this be bypassed if so.
Any help is greatly appreciated.

Thanks,
Jens

 

[Guest]

Temp Resolution I found was putting a text box on the form
and made it invisible and it's control source equla to the
project code and when the Add button is pressed, it
becomes visible and the combo box is invisible. Then when
the user presses refresh, the combo becomes visible and
the text invisible. It seems to work, but now it is not
dummy proof )

Jens