Say ......... you have 10 TextBoxes and 10 ComboBoxes on a form and you are taking their contents into a database tables, i guess you have to make sure that all the TextBoxes and the ComboBoxes are Not Empty ... SO you can do something like This ....
CMDSAVE_CLICK
'The button that transfer contents to tables
if textbox1.text And Textbox2.text and ......................................... etc then
msgbox "Leave No Blanks"
exit sub
end if
Some Codes ............
Some Codes ............
rs.update 'Or however you connect
End Sub
OR, You may use something Like this :-
i will try here to tell the VB project that (TxtBx) represents all the TextBoxes Controls on a form (Form1)
and (Cbos) reporests all the ComboBoxes on the same form .... so the senario may be :
Hey, Form1 .... be aware that (TxtBx) represents all my textboxes on You, and (Cbos) represents all my ComboBoexes On you, so whenever you find one Empty Just Give me a MsgBox and (Exit) the sub . ok?
But If not , continue Updating my database tables .... are we clear, form1 ??
How could we just Code These Lines of Senario .......