How to move the selected record to next form?

G

George

I have a form and subform to enter data into. (some
information is from the Company_Table and details are
added to a company....I want a button to go to a detail
form and subform showing more detail of the selected
record.

How do I carry that record information onto the next form
when the button is selected?
 
F

fredg

I have a form and subform to enter data into. (some
information is from the Company_Table and details are
added to a company....I want a button to go to a detail
form and subform showing more detail of the selected
record.

How do I carry that record information onto the next form
when the button is selected?
Click to expand...

Open the second form using the Where condition argument:
DoCmd.OpenForm "Form2", , , "[CompanyID] = " & Me![CompanyID]
 
Top