How to activate a Query using the current Form Record as the criteria

[BruceJackson]

How to activate a Query using the current Form Record as the criteria?

EG: looking at order no: 012345 in the form and running a query to append this order and other related data into a different table without the need to type in the order no.

Any ideas please?

 

[Remou]

You can refer to a form in the criteria line of a query:
[tt]=Forms!frmForm!OrderNo[/tt]

Or you can run a query through code:
[tt]strSQL="Update tblTable Set Field1='ABC' Where OrderNo=" _
& Forms!frmForm!OrderNo
DoCmd.RunSQL strSQL[/tt]

 

[BruceJackson]

You can refer to a form in the criteria line of a query:
=Forms!frmForm!OrderNo

Spot on!

Thankyou Remou