Problems passing query parameter from textbox

[nikdiva]

Hi all,

I have been fussing around with this all afternoon. I am trying to filter a query from a form's textbox by entering the field name in the query's criteria as such:

Forms![Splashscreen]![DataMerge]![TextCritBuild]

It did work at some point but now I can't get it to work no matter what I adjust.

Any ideas?

Nikki Wright
"You'll get nothing and like it."

 

[swaybright]

I am wondering about your syntax. Should it be
Forms!FormName!ControlName
or
Forms!FormName!SubformName.form!ControlName

 

[nikdiva]

That sort of what I have now:

Forms![Splashscreen]![DataMerge]![TextCritBuild]

Is of the format.....

Forms![Form]![Subform]![Control Name]

Nikki Wright
"You'll get nothing and like it."

 

[LarryDeLaruelle]

Nikki:

Did you use the expression builder to create the reference?

I've found this to be the best way to get the syntax and references correct.

In the criteria cell, right click and select Build. Navigate to the form where the text box lives, then double click on it to set the reference.

HTH

Larry De Laruelle
ldelaruelle@familychildrenscenter.org