This is probably a very simple task but I'm a pretty amateur Access user. Here is the problem:
There is a form where a user enters an input for job number: "JOB001" could be the input for example.
Then I have an append query that will need to append JOB001 into another table.
I have created a button on the form to run this append query. My problem is I don't know how to take the value that the user enters into the form (JOB001 in this case) and feed that into the query's criteria section in the design view.
Any help would be greatly appreciated.
There is a form where a user enters an input for job number: "JOB001" could be the input for example.
Then I have an append query that will need to append JOB001 into another table.
I have created a button on the form to run this append query. My problem is I don't know how to take the value that the user enters into the form (JOB001 in this case) and feed that into the query's criteria section in the design view.
Any help would be greatly appreciated.