Populates combobox with another one from different form

Michael Noze
Michael Noze used Ask the Experts™
on
Hi Experts,

I'd like to know if there is a way to populate a combo box in form2 with a combobox from form1?

IE: I have a cbo in frmInspection, if I made a selection and click on the button "Specification", it
goes to the frm frmSpecifcation and it populates the same value to the cbo in the form.
Planning.accdb
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Developer
Commented:
Please rephrase your question, it's not clear what you mean by "populates the same value"..

E.g. something like this?

Private Sub cboOnThisForm_Click()

  DoCmd.OpenForm "frmSpecifcation"
  Forms("frmSpecifcation").Form.cboOnOtherForm.Value = cboOnThisForm.Value

End Sub

Open in new window

Jim HornSQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015

Commented:
( + Microsoft Access, - Microsoft SQL Server )
John TsioumprisSoftware & Systems Engineer

Commented:
Check my attachment
Planning.accdb

Author

Commented:
Thank you! Yes, it is!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial