requery pop up form with parameter

[Neruda]

Hi,
on a form I have 2 buttons, they both open the same popup form.

button a:
DoCmd.OpenForm "frmCustomers", acNormal, , , acFormAdd, acDialog

button b:
DoCmd.OpenForm "frmCustomers", acNormal, , strWHERE, acFormEdit, acDialog

the query behind the pop up is (shortened):
SELECT tblCustomers.CustomerID, tblCustomers.FirstName, tblCustomers.LastName, [FirstName] & " " & [LastName] AS FullName, tblCustomers.HomePhone, tblCustomers.MobilePhone, tblCustomers.FaxNumber,
FROM tblCustomers;

Regardless which button was pressed to open the popup form, i need to be able to have the option to select a customer in a combobox on the popup form (contains list of customers)and have 1 record in the popup form recordset (using the combobox afterupdate event). I was looking as querydef but can't seem to work out a simple solution.

Thanks

[twinnyfo]

Neruda,

Your strWHERE variable should be a Filter, not a Query. What is the RecordSource of the popup form? Looks like it is (or should be) tblCustomers?

Also, if the Popup is supposed to produce one record for one Customer, based on the record selected from the Combo Box, then your strWHERE variable would look something like this:

strWHERE = "CustomerID = " & Me.cboComboBoxName

Hope this hepps!