Help w/records in form....won't go to next record after

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 4 different forms in my database and on each form I have a command
button on the bottom that I have set to automatically go to the next form.
i'm having a problem with the last form that has a subform that when I enter
the data into the textbox the 2 fields in the subform are automatically
entered. The problem that I have is after the subform is filled in i need to
go back to the first form with the next record.

Thanks
 
What do you mean by "subform is filled"? I would expect terms like "values
are entered into both txtFirstName and txtLastName" or "After the Insert
Event of the subform" or something else a little more descriptive.

I can't imagine what type of system would move a user through 4 separate
forms that aren't either subforms on a main form or similar.
 
I just created this database using 4 different forms and added a subform on
the last form because I thought it would've been easier. I have the last form
in which I enter the last name and the first name and ID number populates
itself. When I enter that info I would like it to go the the first form that
I create starting a new record. Is there an easier way of doing this?

Thanks
 
You give the user a button to click when he/she wants to enter a new record.
If I recall correctly I don't agree with how your application and/or tables
are structured.
 
The way I have my form is each form I have a command button that at exit will
go to the next form. I just get the last form to open up the first form using
a new record.

Thanks
 
So "I just get the last form to open up the first form using a new record"
suggests you have it working the way you want.
 
Back
Top