Moving between forms

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

Guest

How can I move from one form to another without the new form jumping to the
next record? I need to create a series of 15 or so forms which will enter
data to the current record. I can't use pages - it won't let me do more than
5.

I'm using Access 2002.
 
you could use a tab contorl...and that would allow 15 pages...

The other solution is to open another form to the same record...you can do
this with


me.Refresh
docmd.openform "next form name",,,"id = " & me!id

the above assumes you have a primary key id field called id

you could also consider making the form model..so they have to close it to
return to the main form.

The other important part above is to FORCE a disk write BEFORE you open the
form to the SAME record..else you will receive messages about the record
having been edited by someone else (that "other" person will of course been
the form opened to the same record...so, always fore a record save BEFORE
you launch another form to the SAME record.
 
Hi, Albert - many thanks for this.

Which event should I use this code in? The On Close event for Form 1?
 
Chris Walker said:
Hi, Albert - many thanks for this.

Which event should I use this code in? The On Close event for Form 1?
Click to expand...

That code is for the buttion that launches the new form you open. So, it is
not a forms event...but only the code behind your buttion that opens the
next form....
 
Back
Top