Setting query criteria on form - text boxes

  • Thread starter Thread starter anamque
  • Start date Start date
A

anamque

I am very new to VBA.

I have 4 fields: Analyst name, Beginning Date, End Date, and Accts blocked.

How would I set the form so the Analyst can go to the form - enter in the
beginning date and end date - and it will pull the accounts blocked during
the dates specified specific to the Analyst name given?

What is this called? they are all text boxes on the form.
 
Use this criteria in the design view of the query feeding the form --
Analyst --
[Forms]![YourFormName]![TextBoxAnalyst]

AcctBlockDate --
Between CVDate([Forms]![YourFormName]![BeginDate]) AND
CVDate([Forms]![YourFormName]![EndDate])

Use your actual field and text box names.
 
Back
Top