Requery where does it go?

[HJC]

I have a mainform [Customers] from table Customers
with a subform [Phones] from table CustandPhone.

Each customer may have several phone numbers so on the subform I have a combobox that shows all the phone numbers associated with the Customer.

It works fine for the first record on the main form but if I scroll through the customer records the combo box does not update. I know I need some kind of requery event but I am not exactly sure which field/what event I am looking for...

this is what populates the combo box in the subform

SELECT CustandPhone.CUSTID, CustandPhone.PhoneNo
FROM CustandPhone
WHERE
(((CustandPhone.CUSTID)=[forms]![Customers]![phones].[form]![CUSTID]));

any direction would be appreciated

 

[SydneyGeek]

In the form's Current event, put something like...
MyCombo.Requery

Form_Current fires each time you switch to another record.

You can also requery on the combo's Enter event if you prefer; in that case, don't worry about the Current event

Denis