Have access put value into criteria field automatically 1

[jweber]

I am working on a form where (after pressing a button) key elements are deleted. I have a parameter query set to pull up the correct record, however, this still requires the user to enter the ID as it appears on screen. Is there any way to have access put that ID in the criteria when the query is run? (Each time this is done, the ID will be different...)

THANKS!

 

[BillPower]

In the criteria of the ID field in your query type in:

=Forms!YourFormName!YourIDControlName

 

[jweber]

billpower:

Yea! It worked...I tried something similar earlier (before posting) but my syntax was wrong. I appreciate your help!

 

[shanebl]

I've got a question, this helps me on the problem I was having, sort of, What about entering multiple criteria?

 

[jweber]

shanebl:

If you have a date range you can use the Between [Enter first criteria][Enter second criteria].

Otherwise you can use the Or: box under the first criteria, or add an additional place for the same field, and enter criteria there as well.