Auto populate pop up form fields from main form selections

  • Thread starter Thread starter aguywonderer
  • Start date Start date
A

aguywonderer

Guest
"I want to be able to select values from combo boxes on one form(Form1) that will auto fill on pop up form (Form2).

Example: Form1: Select a Name from cbo1, Select a type of Car from cbo2. If I select a Camaro from cbo2 on Form1 nothing should happen, but if I select Corvette from cbo2 I would like the Name selected in cbo1 and the car selected (Corvette) in cbo2 to automatically appear in Form2 fields Name and Car.
 
aguywonderer said:
"I want to be able to select values from combo boxes on one form(Form1) that will auto fill on pop up form (Form2).

Example: Form1: Select a Name from cbo1, Select a type of Car from cbo2. If I select a Camaro from cbo2 on Form1 nothing should happen, but if I select Corvette from cbo2 I would like the Name selected in cbo1 and the car selected (Corvette) in cbo2 to automatically appear in Form2 fields Name and Car.

What do you mean if I select Camero from cbo2 nothiong should happen?

You need to set up a query which will be the Control Source of your Pop-up Form.
In it you can set the criteria to those Comboboxes,

Something like

[Forms]![MainFrom]![cboName]
[Forms]![MainForm]![cboCar]
 

Users who are viewing this thread

Back
Top Bottom