Append Query

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

 

[Guest]

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.