combo box within subform (1 Viewer)

[comicwizard]

I have two combo boxes in a subform that use lookup queries. I can get the combo boxes to work correctly out of sub form in a regular form but can not get the combo boxes to work in the sub form. I have narrowed the issue to the logic in the queries in the secondary and tertiary combo box queries. Here is the part of the secondary query. I think I have to add the primary form name to this part to correct my issues. How would I do that?

primary form = Lookup_fm
sub form = master_tbl_sub_fm

IIf(IsNull([forms]![Master_tbl_sub_fm]![Role1]),[P_ID],[Forms]![Master_tbl_sub_fm]![Role1])

 

[pbaldy]

This should help:

http://www.mvps.org/access/forms/frm0031.htm