Link Forms

[Colorado Spring]

Mornin, all...

I have several forms, all tied to the same table. The PK for the table is ObjectID (an auto number field). The reason for so many forms tied to the one table is, I'm using them as "wizards" to explain the types of information and give some examples. So, on Form 1, I have the PK and Description (a memo field). On Form 2, I have the PK and Objectives (a memo field), etc. I want to be able to click a button on Form 1 which will close Form 1 and take me to Form 2, same record (creating a new record with the same ObjectID). However, Form 2 continues to create a new record in the table.

Can someone help me with this, please.

Thanx so much ;<)

 

[grnzbra]

Perhaps you could call the second form and pass the PK as OpenArgs parameter and then have the second form select the record based on the OpenArgs parameter.

 

[Colorado Spring]

Thanx for the reply grnzbra...can you give me a start on the code?

Thanx again

 

[Joebax]

Look up DoCmd.OpenForm.

You can set the form type and parameters in that function and then refer to them in the form load of the called form