passing value from subform
I have a Form “Developments” with a subform “Lots”. My “Lots” table has a
auto number key [LotID]. I want to display fi;tered “LotDetail” form based
on which lot I select on the lots subform AND be able to Add/Edit the lot
detail records. Problem: When I display my LotDetail records, the correct
records show but I have to manually enter the “LotID” in order to add
records. The “lotDetail” form is not picking up that lotID from the subform
“Lots” How do I pass this value? (I’m open the “LotDetail” with a macro
where a where condition LotID=forms!Lotsubform!LotID.
|