Changing the focus from the main form to the subfo (Ms Access 2007)
In the book MS Access 2000 VBA, translated into the dutch language i read:
"When a form own a subform, and the focus is moved from the main form to the subform", that's equal to saving the data into the main form. On the same time the validationrule of the table that makes part of the recordsource of the form is checked.
Now to check this behavior if set for the field "ClientID" of a table "tblClients", that makes part of the recordsource of my mainform frmOrders as validationrule: "Is not Null" and a apropriate text as validationtext.
Now I open my form frmOrders. On this moment I see only the commandbuttons of frmOrders. When i click on the commandbutton "CmdNew", the whole frmOrders becomes visible as wel as the subform and is set ready to receive new data for a new order. If now by accicent I click in the first field of my subform without first entering a clientnumber in the field "Client_ID" in the mainform,no message becomes visible to let me know that i first of all have to enter a ClienID number, because this may not be null. Why doesn't this happens
In how far is it wright what is mentioned in the book about checking the validationrule of the table when moving the focus from the mainform to the subform?
Re: Changing the focus from the main form to the subfo (Ms Access 2007)
If you haven't entered anything in the main form, there is no record yet. So when you move to the subform, there is nothing to save, and hence the validation rule isn't checked.
If you enter something in any of the fields on the main form, then move to the subform, you should see the validation message if ClientID is still blank.