Setting query criteria on form - text boxes

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.
 
K

KARL DEWEY

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.
 

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

Clearing combo boxes and a text box 2
Creating a Search using a combo box and then creating a report. 4
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Dynamic Naming of Form Button 3
Copy previous record into form field 0
Clearing Fields in a Word Form 5
Text duplication question 0
Creating a Chart on form from selected data in query. 0

Top