Append Query in Filter Name?

[DissentChick]

Please excuse my ignorance. I'm not sure if I can use the name of an Append
query in the filter name field of a macro without it actually....appending?
The records I need to come up in the form are in this query, but I do not
want them to add again. Basically I want the most recently appended records
to be displayed in my form. I'd also like to add a condition where if those
records have COMP in the Status field, they are not displayed. Could anyone
help with this? Thanks in advance.

 

[Nikos Yannacopoulos]

No, you can't do that. make a copy of the append query, open it in
design mode and change it to a simple Select query, then just add the
"COMP" criterion on the Status field. When done, base the form on this
query.

HTH,
Nikos

 

[DissentChick]

Thank you so much! This will work just fine.
Aaron