Multi Functional Button

[June]

Hello-

I use Access 2000.

In Access 2000, I need to save a record in Form1 (i.e.
save the data just entered), then open Form2 with the ID
field from the previous form (the same record), and close
Form1.

I can accomplish part 2: (open form using that current
record and displaying the ID value just entered, so as to
add info to this record)

....by creating a button in the Wizard, such that the ID
control from both forms is set to match.

How do I accompish ALL 3 with just One Button (and
therefore one macro)?

I have 1 table with many fields. I am splitting up the
data entry with different forms.

Thanks!

 

[GVaught]

If you have one table with many fields, then I would say that you may have
an 'unnormalized' database.
Perhaps before you go the route of trying to create multiple forms for one
table, you run your table through Access's Table Analyzer. Be sure to make a
copy of your table first. The analyzer will let you know if your table is
not normalized; a key to database relationships and data integrity.