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
 

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

Change Record Source 9
Count records in report's recordsource 1
subreport recordsource 1
Setting Record Source in Report_Open Event 2
Problem passing SQL string to Record Source property of a Report 3
Setting Report's RecordSource 8
Filter Form Based on Subform Combo Field Problem 1
Changing Report Record Source 4

Back
Top