Good morning all,
I need your help with what I hope is a simple question: I have a form with a subform, respectively based on Table1 and Table2. Table2 contains a Required field named "Status".
I have a button in the main form with the following code:
Problem: hitting the button does not prevent users from opening the report when they have not entered the appropriate information in the "Status" field (whose control is a combobox named CmbStatus) in the subform.Code:Private Sub Button_Click() DoCmd.OpenReport "E_Inspection", acViewPreview, , "IDInspection = " & Me.TxtID End Sub
Is there a way to prevent opening the report if Status has not been entered?
Thank you all in advance!