Select record source based on criteria

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

Guest

I want to select a query based on criteria in a table and I'm not sure where
to enter the code or if the code is correct.

If Me.PCRHireDate > #12/31/2003# Then Me.RecordSource = "days"
Else: Me.RecordSource = "DaysX"
End If
 
Back
Top