Forms based on Queries with no result

[John Big Booty]

If you have a form that is based on a select query that has selected no records, the form will display as totally blank.

One way to avoid this is to ensure that the query is always able to select at lest one record; but Is there a way a message can be displayed if no records are selected?

 

[RuralGuy]

Me.RecordSet.RecordCount = 0 Tells you there are no records. You could test for this in the OnLoad event of the form and put up a MsgBox.

 

[John Big Booty]

Thanks RG, just what I was looking for

 

[RuralGuy]

Glad to be of assistance.