Private Sub cmd_FicheProd.jpg.zip
frm_DetailProduit_Scolaire_E.jpg.zip
Here what I would like to do. In the frm_DetailProduit_Scolaire_E (see above attachment) there is a field called binding color, within that field you can choose various color and also the option "To be determined".
When I click on the View Production Sheet at the bottom of that form, there the above code that calculate a "DateTerminaison", then open the Production sheet (see below the attachment), (sorry guy's this report is only in French) which is printed and sent to the production floor.
I would like to put in that code a vbCritical which would prevent the report to open if in the color field the option "To be determined" is selected. The "To be determined" option as to stay because it's put there for the purpose when the salesman as to send a order form to the client to be approved and sign even though the client as not chosen is finale choice on binding color. The vbCritical has to informed the salesman that he as to change the "To be determined" choice.
All this to prevent the chaos of having a production sheet reach the production floor which would require the production personnel to contact the salesman and to have the said binding to be produce in house according to the querry generate by this program. (about 1500 order to process in 2 month).
rpt_FicheProductionAupel.jpg.zip
Hope this is enough explanation.
Thanks very much.