Query for current record

[zooyo]

Alright so this is driving me nuts and I can not find a straight answer on this.



I have a form that has a button that links to my query. Within this query I need to it to default to the current record (ID) that is displayed in my form. Please help I am about ready to smash my computer.

And yes I am aware this is probably something super simple, I am just a frustrated newbie.

[pbaldy]

If you mean restrict the query to the current record, add a criteria on the ID field that points to the form. You can use the build function or:

Forms Refer to Form and Subform properties and controls

[zooyo]

I have tried to enter in a criteria where it points to the ID on the form but it doesn't. It just brings up all the records. Perhaps I am putting it in wrong? This is what my criteria says - "[Forms]![Form Name]![ID]".

[pbaldy]

If the quotes are part of your criteria, they shouldn't be. Also, did you put in your actual form and textbox names?