combo box

[robart6]

Please help a newbie!

I have a form with a combo box. When the user selects a name from the combo box, I want a new form to open with the record corresponding to the name from the combo box. I know how to do this when the combo box resides on the same form as the corresponding record but need to do it on two separate forms.

All help will be greatly appreciated!

 

[dan-cat]

DoCmd.OpenForm "YourFormName", acNormal, , "[YourFieldName] = Forms!YourFormName!YourFieldName"

 

[dcx693]

Syntax correction:
DoCmd.OpenForm "frmYourFormName", acNormal, , "[YourFieldName] =" & Me.cboFieldName

This assumes that frmYourFieldName is the form you want to open, YourFieldName is the name of the field in that form's recordsource that you want to match to the value in the combo box, and that cboFieldName is the name of the combo box on the open form. It also assumes that cboFieldName contains numeric data.

 

[robart6]

Dan-Cat, thank you very much for the prompt reply and successful statement.

 

[robart6]

Thanks, dcs693. Your statement, using Me! instead of Forms!, also works. I appreciate the help.

 

[dan-cat]

No worries

 

[dcx693]

As long as it works....