Using a Forms (unbound) Text box in an Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Howdy from Oklahoma!!

I am just learning ACCESS and I have a form that some will input a Job# and
then hit a button to activate an Append query where the Job# is used in the
query as one of the appended fields. The query works fine, except that it
will not pickup a new value form the forms text box until the the form and
query are restarted. I can change the value in the text box but when i run
the append query it still has the original value if i have not restarted the
form and query. I am doing this from "Design view" of the query with the
form open and a value inputted into the text box.

The expression I am using in the query is: (FYI, the form name is
[frm_startup2] and the unbound text box is named [job])

[forms]![frm_startup2]![job]

And as ai mentioned earlier, it works correctly the first time but then will
not pick up new values if they are changes and the query is ran again.

Any Assistance would be greatly appreciated!!!
As always. THANKS IN ADVANCE!!!!

Chip
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Supresssing the Automatic Bracketing of an expression 6
Access 2000 append unbound text box values to a table 0
Pull a field from a form to be the criteria of an append query 0
Append query from form input - Access 2000 1
Exicute an append query in an after update event 0
Multiple Parameter Crosstab query filter by form 1
Access 2007 - append query only appending 0 rows??? 0
query result in text box 2

Back
Top