moose
02-14-2002, 07:01 AM
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