Control Qry by time limit in form

J

JB

I have a form which contains a subquery (like a subform). I want to be able to control the query's data by

a) giving the ORDERDATE a limited criteria (only one month like 1-10-03 to 31-10-03)

For this, I have made 2 unbound text boxes in the form with the names BeginningDate and EndingDate

b) It should display the results of one customer only - How do you bind the customer ID with the CustomerID text box in the main form

Please help.
 

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

Setting the number of Tabs in a Tab Control 0
Checkbox will not check 5
Use a Qry as a filter in a form 9
Invoicing by month 1
SUBQUERY IN A FORM 0
Creating Top 10 in linked subform 1
Validation Rules for a Control on a Form (?) 4
Default Date in a control on a form 3

Top