moose
c'mon Chelsea
- Local time
- Today, 02:38
- Joined
- May 18, 2001
- Messages
- 139
in my Query i have 4 fields, Number - Description - Customer - Date.
the data all comes from one table but i only want the form to show data from the "Number" field when the "Date" field is blank.
Can someone please give me the criteria statement to do this please.
I would like to show the results in text boxes (1 for each) when the user selects a customer and a product from combo boxes, so the query will run in the afterupdate event of the second combo box
the data all comes from one table but i only want the form to show data from the "Number" field when the "Date" field is blank.
Can someone please give me the criteria statement to do this please.
I would like to show the results in text boxes (1 for each) when the user selects a customer and a product from combo boxes, so the query will run in the afterupdate event of the second combo box