Reference Current Record in Query?

  • Thread starter Thread starter Jim/Chris
  • Start date Start date
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?
 
Back
Top