Combo Boxes in Subforms (1 Viewer)

[Access Granted]

In the datbase I am creating I have a master-detail form... I want to be able to lookup a customer on the master form (using a combo box) and it finds the record on the master form and brings up the details from the table. Now have a subform on this table that lists the items that these customers have in there records.. but I also want to be able to select another item from this row to add it to the records.. I want to use a combo box on the row.. so I can select the item and then all the items details are displayed on the current row.. just like the master form. Now I have got the combo box to work but the other details are not showing up.. what can I do.. I am not sure what the problem is. For the master form I am using the customer table.. for the sub form I am using an order-details table.. that combines the products and the customers so the customers can have a 1-many product ratio.

I appreciate your time in getting back to me.

 

[Travis]

sounds to me like you are missing the requery of the subform.

Make sure that you have this code on the AfterUpdate of your Combobox on the Master Form:

me.[SubFormName].Requery