Multiple forms for Data Entry

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I have a 2000 access database that has multiple forms for
data entry only. When I get to the last page of entry I
need to save and move to the next record opening the first
form.

Example: record 200 in form "A", progress thru
forms, "B", "C", "D" and "E". On "E" need to push next
record button that will take the user to the next Record
(201) on Form "A".

Any suggestions on how I can accomplish this?

Thanks,
Frank
 
On form "E" your next record button would have code to
open your form "A" like:

DoCmd.OpenForm "YourFormA", acNormal, , , acFormAdd

HTH

Byron
 
Frank said:
I have a 2000 access database that has multiple forms for
data entry only. When I get to the last page of entry I
need to save and move to the next record opening the first
form.
Click to expand...

This has me a bit queasy. Are these five forms for five tables? or for one abnormally wide table? Are the different forms updating the same record, or related records? How are you navigating from one form to the next?

Typically one would have ONE data entry form, probably with several Subforms for related tables. Rather than closing FormA and opening FormB, you'ld have FormB sitting right on FormA (perhaps on a tab page) as a Subform; the "go back to FormA" scenario would not arise.
 
Back
Top