Connecting Tech Pros Worldwide Forums | Help | Site Map

Answer to Saving Form With Required Field

Newbie
 
Join Date: Oct 2007
Posts: 19
#1: Mar 10 '08
I had posted a question asking for help with printing only required fields on a form - both Sierra7 and Denburt answered me and gave me valuable information. I had to make it a little simpler to get it to work correctly but i figured out how to do it and wanted to let them know of my solution since I said I'd let them know what works:

The following code was written for the print button on the form:

Private Sub Command95_Click()
On Err Go To Err_Command95_Click

If IsNull(Me.Action_Requested) Or IsNull(Me.T_L) Or IsNull(Me.RequestNumberTextField) Or ....Etc thru all the fields Then
MsgBox "One or more required fields are empty - All boxes on the form must be filled out before you can print."

Else

Reply


Similar Microsoft Access / VBA bytes