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.

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