Reference Current Record in Query?

J

Jim/Chris

1. Add this to the query's Criteria of your key field
[Forms]![NameOfForm]![NameOfkeyfield]

2. Put this in the query's criteria of the date
<[Forms]![NameOfForm]![NameOfdatefield]

Jim
-----Original Message-----
How do you reference the current record in a query?

How do you have a query pull all records with a date less
Click to expand...
than the date of the current record in a form?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy previous record into form field 0
Mail Merge skipping records/sending one at a time 0
query to show where no data in a stated column 0
Query to show details of dataset when one type of data is still blank 1
Query refer to field on current open form 0
Show all records 12
Form fields don't need to always be filled in 1
Query in a sub form 1

Top