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
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