Append Query

A

Andy Josolyne

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.
 
J

Jerry Whittle

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.
 
Top