Moving between forms

C

Chris Walker

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.
 
A

Albert D.Kallal

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.
 
C

Chris Walker

Hi, Albert - many thanks for this.

Which event should I use this code in? The On Close event for Form 1?
 
A

Albert D.Kallal

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....
 
Top