How to make sure to provide data in all controls on a form

[RaoAli]

how to make sure that data in all controls on a form including tabs is provided before moving to next record?? Hope someone will find time to answer :)
Thanks

[mbizup]

You can use the before update event to check your controls, and cancel the event if your validation checks fail. Note that controls in tabs are handled the same way as those outside of the tab control (unless any of the controls happen to be in sub forms):

Private Sub Form_BeforeUpdate(Cancel as integer)
   dim blCancelUpdate as boolean
   if me.txtMytextbox & "" = "" then blCancelUpdate =true
   if me.cboMyCombo & "" = "" then blCancelUpdate =true
   'etc
   if blCancelUpdate =true then
      Msgbox "Please fill in all data"
      Cancel = true
   end if
end sub

You may also be able to do this more generically:

Private Sub Form_BeforeUpdate(Cancel as integer)
   dim blCancelUpdate as Boolean
   dim ctl as control
   for each ctl in me.controls
    if ctl.controltype = actextbox or ctl.controltype = accombobox then 
      if ctl & "" = "" then blCancelUpdate =true
   end if
   if blCancelUpdate =true then
      Msgbox "Please fill in all data"
      Cancel = true
   end if
end sub

[RaoAli]

thank you for the reply. in addition to this could you please suggest some way to move focus from control on main form to the controls on Tab Control and similarly from last control of tab to first control of next tab and so on.

thank you once again.

[zmbd]

see my post here:
https://bytes.com/topic/access/answe...ox#post3798634

Should do all you have asked for

[NeoPa]

In its simplest form you just need to ensure the tables are designed such that all mandatory fields are set as such.

Some people have more complex requirements, but for your specific question that is all you need.