Append Query

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

Guest

How do I modify the append query to only append the displayed form record,
and does the expression go into the criteria?

Many thanks for your anticipated support.
 
Assuming that the form shows the primary key for the table, put something
like below in the criteria under the primary key field in the query:

[Forms]![frmParameter]![txtParameter]

Change the frmParameter and txtParameter to the correct form and text box
name.
 

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

Append Query Issue 0
Append a Single Record 5
Schedule Auto run Query on append table 0
Pull a field from a form to be the criteria of an append query 0
Access 2007 - append query only appending 0 rows??? 0
Access 2010 append query to SQL is very slow 0
query field names changing to expr#: 8
Preventing duplicate entries with an Append Query 3

Back
Top