SUBQUERY IN A FORM

J

JB

Wayne, could you please get me out of this?

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