Appen Query only gathering data from one single form

[BWG3]

Is it possible to run an append query that only gathers data from one single open form? ie: I have an open form and when I click a button, I want the append query to gather just the names selected on that form, not all the names from every person on every form. If this is possible, can anyone please explain to me how to accomplish this. Thanks for your help. Happy Holidays.

 

[CEH]

So it sounds like you are just trying to have one record in the results of your query....... Put a parameter in the recordID of your query..... Look at the query grid...under the RecordID field "criteria" reference the ID on the form. like......
[Forms]![frmOpenForm]![RecordID]

 

[BWG3]

Thanks, Curtis. Is there anyway to have it automatically fill in for the RecordID number? As of right now, when I run the code in the "criteria", it still prompts me to enter in the recordID number, even when I have the button on the open form.

 

[BWG3]

I fixed the problem. I had the wrong form name in my criteria command . Thanks for your help, Curtis.