Append existing data from subform button to new record

[Guest]

I've read some responses to this problem, but have not found the exact
solution I need. From a subform, I have a button that executes an append
query. The query is set to take certain fields from the current record and
copy them to a new record. Now this already works fine if I just open the
subform by itself and push the button. But when I open the main form WITH
the subform (where my button is located), it asks me for the criteria rather
than look at the Key Record #. How can I get my subform button to execute
the query properly? I don't know why it works by opening the subform by
itself, but not when it opens with the main form. Any help would be greatly
appreciated!

 

[Guest]

I figured it out. For anyone else asking this kind of question, I made sure
my query criteria said:

[Forms]![Contracts Orders Summary]![Contract Order Subform]![Order ID]

The point here is that I didn't include the main form FIRST [Contracts
Orders Summary] and THEN the subform. I just had the subform name and it
wasn't checking the criteria right.