form-subform constructions

[gerard1979]

I'm wondering how it's possible that simple things give sometimes more troubles then real stuff.
I have a simple form with subform.
I have on the subform a combobox
on the subform have the
P_fabr_AfterUpdate
me.p_naam.requery
end sub
no problem
but I make a query for the P_naam field and bound a field to
forms!subfrm1!P_fabr in the query design. But the query see the restriction as a parameter? Why?

thnx
gerard

 

[KenReay]

Hi

Is P_naam on the mainform?

You need to address items on the sub form via the FORM property of the subform control:

Me.subfrm1.FORM.P_fabr

Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use