Msg when no record

Topic

New Reply

Hi!

I have frmStudentEvaluation. When it loads, if there is no record I need a msgbox that states there is no active record. I’m not sure how to code this.

Thanks,
Leesha

Reply | Quote

Replies

You could use the On Load event of the form (or add code to the On Load event procedure if you already have one):

Code:

Private Sub Form_Load()
  If Me.RecordsetClone.RecordCount = 0 Then
	MsgBox "There are no records to display!", vbInformation
  End If
End Sub

Reply | Quote

Thanks! That’s perfect!

Leesha

Reply | Quote