Can I grab the ID of a Form record and use it in VBA code when running a query?

[Dave14867]

I have a form that saves records to a table, the primary key is the ID (WorkOrderID). I have a command button on the form to run a query to append data to another table based on the inputs on the form.

Is there a way with VBA to save the ID of the open form and use it in the query? I am not very familiar with VBA or SQL so be kind please.

Thanks in advance.



Dave

[davegri]

You might not need VBA, if this will do the trick.

In the query grid design view, the criteria under WorkOrderID would be:

Forms!YourFormName!WorkOrderID

The form must be open with valid data when the query is invoked.

[Dave14867]

That is awesome, I will try that davegri. I was hoping it would be something like that.