Access 2010 Alert Prompt when query in subform shows no results
Posted on 2012-09-06
I have a subform who's record source is loaded from a query "qrySchedules_Search_Results1" and who's purpose is to show available "Schedules" in datasheet view.
The parent form has 2 combo boxes and the user has to make a selection from both these and then press the "Search" button (I have vba validation behind the search button to ensure a value is selected from each cbo).
After valid cbo selections have been made, the entire form is refreshed and if there are any "Schedule" results to be shown these will be displayed in the subform.
This is all working fine!!
However, my dilema is that when the subform has no results to show i want a msgbox informing the user of this.
I have put the following code in the "On Load" event of the subform, but this does not seem to work.
Private Sub Form_Load()
If IsNull(Me.HASchedule_ID) Then
MsgBox "No Schedules Found"
Any ideas please?