.addnew problem

[Jimh]

I am using a single form with multiple tabs. One of which is tied to a second
table and is being updated with code. I want the user to use this tab for as
many entries as he knows about at the time. Each newly added record is tied
to the first table via a standard ID field. I seem to be able to add the
first record but when I clear the fields on the form for another entry, the
record number field remains the same as the original value when the user
first clicked on the tab. Any code samples around to handle this situation.
Thanks.

 

[SteveM]

What do you mean by 'when I clear the fields on the form for another entry'?

What is the ControlSource of the record number field?

Steve

 

[Jimh]

One of the files is a projects file and the second one is a resources file.
There can be multiple resources assigned to a single project. The control
source for the file I'm attempting to add the new resources to is the project
resources file. After the initial add of the first resource, the data remains

 

[SteveM]

Is this a bound or unbound form?
What is the ControlSource setting for this form?
Do you have navigation buttons at the bottom of your form?

You never have to clear fields in order to enter new information, you just
advance to a new record using the navigation buttons.

Steve