Query critera from form that is now a suborm

[gem1204]

I have a form that uses a query that gets criteria from the form. Example:

The form name is frmBookingInfo and the criteria for the query that is the recordset is BookingID = [Forms]![frmBookingInfo]![txtLkBookingID]

I have my query set up as the recordset with the criteria coming from 10 fields with criteria coming from text boxes on the form. I have it set up and everything was working great. Now I’ve been told that the form can be used as a stand alone form or it could also be used on a navigation form. I know from experience the query won’t work from the navigation form because the query is not referencing the correct form which would now be a subform.

I know the solution would be to modify the query parameters to user paramaters and enter the paramaters manually or thru vba which would really be a hassle especially since I was lazy and didn’t bother to create them as named paramaters. and I'n not sure how to supply the paramaters when the form opens

Has anyone ever had this problem before and if so how did you fix it? -

[MatthewR]

Would something like this work as your criteria?

IIF(isnull([Forms]![frmBookingInfo]![txtLkBookingID]),Forms![NAVIGATION FORM NAME]![SUBFORM CONTROL NAME].Form![txtLkBookingID],​[Forms]![frmBookingInfo]![txtLkBookingID])