Open filtered form from unbound switchboard

[BarryMK]

I get the feeling I'm really missing something glaringly obvious here but I'm struggling.....

I have a combo box on my switchboard that looks up field txtOfficer in a query and then want it to open up a new form containing only those records relating to the officer name selectedtxtOfficer

The rowsource for the combo is:

SELECT DISTINCTROW [qryMain].[txtName] FROM [qryMain];

and the on click event is:

DoCmd.OpenForm "frmFiltered", , , "[txtName] = " & Me.cmbOfficer.Column(0), acFormEdit

When I select a name from the combo I get a parameter box and have to type in the name to open up the filtered records form. How can I get rid of it so the selection is one seamless process?

 

[BLeslie88]

.

"[txtName] = '" & Me.cmbOfficer.Column(0) & "'", acFormEdit

May be all you are missing...

 

[BarryMK]

Thank you Brian that did the business.