getting the correct value on a requery in a subform
Posted on 2003-03-11
Hi, I'm trying to get a combobox on a control on a subform to requery, so the new values that i add will show up.
I have a form called Study_Information and a subform called LotStudy_subform. The record source for the subform is a query. Here is the SQL for the query, if needed:
SELECT DISTINCTROW LotStudy.InternalStudyID, LotStudy.LotID, Lot.SpeciesID, Lot.StrainID
FROM Lot INNER JOIN LotStudy ON Lot.LotID = LotStudy.LotID;
There is a combo box on the LotStudy_subform called "LotID". I want this control to requery automatically, when I click the combo box. I'll be checking back periodically to see if you guys needs additional information.