3 3699wat Registered User. Local time Today, 03:11 Joined Oct 28, 2002 Messages 83 Nov 7, 2002 #1 Need help with the code on the on click event of a command button on formA to stop formB from opening if the listbox on formB is empty
Need help with the code on the on click event of a command button on formA to stop formB from opening if the listbox on formB is empty
R Rob.Mills Registered User. Local time Today, 03:11 Joined Aug 29, 2002 Messages 871 Nov 7, 2002 #2 Try: If not IsNull(ListBox) Then DoCmd.OpenForm "FormName" End If You can add an 'Else' line to make a msgbox if it's null.
Try: If not IsNull(ListBox) Then DoCmd.OpenForm "FormName" End If You can add an 'Else' line to make a msgbox if it's null.
