Subform control reference

[SunTop]

Hello everyone,


Suppose I have a form and on that form I have a subform and on that subform I have one list box and one text box and I need to filter the list box based on the value of the text box. So I have to put a reference to the text box on the criteria of the embedded query of the list box. So how do you write the reference of the text box value ? I did some googling and I came up with this format :

Forms!MainformName!SubformName!Form!TextBoxName.Te xt

But it did not work, I keep getting enter parameter popup window when I open the form or run the query. Then I tried this format:

Forms!SubformName!TextBoxName.Text

But this only works when I open the subfrom directly from the navigation pane , if I open the main form I get the enter parameter popup window again.
What is it that I am doing wrong ?

[ranman256]

You dont need the '.text'.
you did it correctly, Forms!MainformName!SubformName!Form!TextBoxName (no .text needed)
in the query criteria , always use the BUILDER. It gets the object spelling and path name correct, you just click on it. And yours looks correct.

Note: In the textbox AFTERUPDATE event, you must refresh the listbox so it can see the change:

sub txtBox_afterupdate()
  listbox.requery
end sub

[SunTop]

thanks for your replay ranman256,

I am still getting the enter parameter window even when I removed the text part from the reference, I tried using the expression builder as you have suggested, but in the builder I only get as far as subformName and then I can't find the Text Box control name

[ranman256]

The param window is happening because something is misspelled or no longer exists.
the builder WILL show every text box.

If in a query: make sure every field is correct
if in a report: check the grouping for bad fields