Combo box update subform

[jbphoenix]

I've got a subform (frm_Edit) in datasheet view. The record source is a table. The main form (frm_RMA) has a combo box whose row source is - SELECT tbl_RMA_Inspection.RMA_ID FROM tbl_RMA_Inspection GROUP BY tbl_RMA_Inspection.RMA_ID;

I need the user to be able to choose an RMA number from the combobox and have the data pull up in frm_Edit (the subform) and update or modify the record.

I can't get the records to be on the subform. I had the subform record source set to a query and then the query criteria equal to the combobox on the main form (frm_RMA) but I still couldn't get the RMA data on the subform.

Any help would be greatly appreciated. Thanks

 

[coyote]

Few questions first
1. Is the form a data entry form
2. What are the links between the main form and the subform

If the form is data entry then you need to set its Data entry property to no
Then the combobox field you are selecting the data from should have a corresponding field in the subform.

In the after update event of the combobox put this code

Me.YoursubformName.requery


Cheers