N
Nick1966
Hi
I have a Main Form and Sub Form to manage orders on an Access [2000] DBase,
the forms are based on two queries in a One to Many relationship. The Main
Form contains the OrderNo, DateRecvd, etc and a checkbox field to complete
the order once all the details are completed in the Sub Form. The Sub Form
contains the details of the order and also has a checkbox field to close the
lines that are completed.
Everything is OK so long as the checkbox on the Main Form is not checked
until all the order details in the Sub Form have been completed otherwise
the user has to go in and uncheck the box to show the remaining order
details. Ideally whayt I would like is for the Order to be closed
automatically once all the details have been completed and hide or do away
with the Main Form checkbox or a way of preventing the user ticking the Main
Form tickbox until all the details are complete.
Hope that makes sense. Any suggestions welcome
Nick
I have a Main Form and Sub Form to manage orders on an Access [2000] DBase,
the forms are based on two queries in a One to Many relationship. The Main
Form contains the OrderNo, DateRecvd, etc and a checkbox field to complete
the order once all the details are completed in the Sub Form. The Sub Form
contains the details of the order and also has a checkbox field to close the
lines that are completed.
Everything is OK so long as the checkbox on the Main Form is not checked
until all the order details in the Sub Form have been completed otherwise
the user has to go in and uncheck the box to show the remaining order
details. Ideally whayt I would like is for the Order to be closed
automatically once all the details have been completed and hide or do away
with the Main Form checkbox or a way of preventing the user ticking the Main
Form tickbox until all the details are complete.
Hope that makes sense. Any suggestions welcome
Nick