PLEASE HELP: Passing a text box value to an update query

[JimMiller]

I am trying to use a text box value that is on a form in a UPDATE query criteria field. Some things you need to know:

1) I have placed the varible name in the query criteria field.
2) The text box I am trying pull the value from is unbound.
3) The form is open and loaded when I run the query.

When the query is run, nothing gets passed to the criteria field. The end result is that the criteria field uses a null value.

I have two questions:

1) Is it possible to pass a unbound text box value from a form to an update query criteria field.

2) If so, how do I get the value passed successfully.

 

[JimMiller]

Additional info:

The unbound text box value is being dynamically created by buttons. The value in the text box is being used in the criteria field of an Update query.

 

[jwindon]

Sound like you may not have the syntax right.

frmSearchForm has the unbound control [Topic]

(the label or "textbox" name is irrelevant, you need to enter the "name" of the control, see properties tab)


Criteria in the qrySearchByTopic would be

=Forms!frmSearchForm![Topic]

 

[JimMiller]

I am using the name of the control. The control variable is not pulling the value from ther form. Do you think it could be that the control is not loaded or in scope?