How to move the selected record to next form?

  • Thread starter Thread starter George
  • Start date Start date
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?
 
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]
 
Back
Top