Append and Delete query parameters not working in Macro!

[tim_tims33]

HI,



I've been creating a simple macro which will append data and then delete data from a table.

The criteria for the queries is found in a form, and this is used as a paramter.

However, when i run this all as a macro...the append and delete queries somehow can't read the criteria in the form. Rather...i have to type in the criteria again...and then it works.

I have attached a copy of my DB.

1. Go to frmArchiveStock
2. Select a stock from the combo box (this the criteria for the append and delete queries)
3. Click the button to run macro mcrStockArchive.

How can i get the queries to pick up the value entered in the form to act as a criteria when they run?

Please help if you can.

Thanks

[alansidman]

Your combo box is bound to the first column in your query. StockID. Move your criteria to the StockID field in your append query and remove it from the description. You will probably have to do the same for the update query. Because you have it in the description section and the combo box is showing the StockID, there will never be a valid execution of the queries.

HTH

Alan