Link subForm to unbound field in master form

[TreyS]

I have a (sub)form that uses a prameterized query to look up records in a table based on a "Like" string match. It works by itself.

I would like to include it in a form with a text box to accept the search string, then populate the subForm.

I created the form, with an unbound text field, and used that as the link to the subForm. As soon as the form is invoked, before it displays, a dialog prompts for the search string. The expected records display in the subForm, but the text field is not populated.

I think I would like to trigger the subForm with the "On Lost Focus" event of the text field.

Thanks for any help...

[June7]

So where is the search input? Probably issue due to subform loads first so referenced search string is not available to the query, thence the popup prompt.

Post query SQL statement.

[TreyS]

So where is the search input? Probably issue due to subform loads first so referenced search string is not available to the query, thence the popup prompt.

Post query SQL statement.

I guess I'll just call the (sub)form directly and use the popup as the input. This was just a personal utility...

[Minty]

As June stated subform loads first, so try having the subform object not set until you have an entry in your text box.