action query not working in form when button clicked

Hi all,

I am trying to make a books database, and in the orders form is a button so that when a shipment of books come in from a supplier, all records that relate to that supplier will be transfered to another table "tbl_Books_In_Stock" from the "tbl_Books_Ordered" table. So far i am trying to make the select query work before using the append to query.

How do I make the criteria in the query to be the same as that in the ID field in the form?


Thanks in advance

I got it working!!!


I put this in the criteria in the query:

[Forms]![frm_Book_Entry_form]![frm_Books_Ordered_TableView].[Form]![Supplier_ABN]

Thanks to all who give it brain time!!!