Pull a field from a form to be the criteria of an append query

I

igora08

Joined
May 20, 2011
Messages
1
Reaction score
0
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.
 

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

Access 2007 - append query only appending 0 rows??? 0
Exicute an append query in an after update event 0
Add criteria to a append query 2
Criteria in append querie 3
Append query from form input - Access 2000 1
append query 5
Append Query Date Criteria Problem. 13
Append query to append lots of record with range input 7

Top