Hello,
I have a couple of questions.
I have a form which has a List box displaying records where the a Field called Select is set to False. I have put a subform on this form which is a continues form linked to another query from the same table as above, this query shows all records where the field Select is TRUE.
I have then a button which will create a order. What i want the button to do first is ensure the user has entered data in neccessary fields (Validate) before the other action is carried out.
I cant put validation on the table as the records are imported.
How can i tell the button to check the whole recordset with in the query, to see if there are any fields with no values.
Also because of the above, (1 table but two queries dispalying similar information) i keep getting the save, copy to clipboard, drop changes, when i make a change to one of the queries
does anybody know how to resolve the problems?
thanks in advance
I have a couple of questions.
I have a form which has a List box displaying records where the a Field called Select is set to False. I have put a subform on this form which is a continues form linked to another query from the same table as above, this query shows all records where the field Select is TRUE.
I have then a button which will create a order. What i want the button to do first is ensure the user has entered data in neccessary fields (Validate) before the other action is carried out.
I cant put validation on the table as the records are imported.
How can i tell the button to check the whole recordset with in the query, to see if there are any fields with no values.
Also because of the above, (1 table but two queries dispalying similar information) i keep getting the save, copy to clipboard, drop changes, when i make a change to one of the queries
does anybody know how to resolve the problems?
thanks in advance
