C
Chip
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
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