lookup values for specific dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables of concern; the lookup table lists work codes by year, the
master table lists projects with associated work codes. HOWEVER, I have the
same work code for different years, and, unforunately they signify different
billing accounts.
Is there a way to set a lookup to pull only those codes for the year listed
in the active record?
Thanks,
JKS
 
I have two tables of concern; the lookup table lists work codes by year, the
master table lists projects with associated work codes. HOWEVER, I have the
same work code for different years, and, unforunately they signify different
billing accounts.
Is there a way to set a lookup to pull only those codes for the year listed
in the active record?
Thanks,
JKS
Click to expand...

Sure; base the combo on a query selecting the records for that year.
You don't say how your tables or your form are structured, but try
creating a query on the work code table using a criterion

=[Forms]![YourForm]![SomeControlName]

to filter the combo box to the appropriate year.

Or, in a Query, include the year in the join of the query.

John W. Vinson[MVP]
 
Back
Top