Forms based on Queries with no result

John Big Booty

AWF VIP

Local time

Today, 14:30

Joined

Aug 29, 2005

Messages

8,262

• Dec 16, 2005

• #1

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

AWF VIP

Local time

Yesterday, 22:30

Joined

Jul 2, 2005

Messages

13,825

• Dec 16, 2005

• #2

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

AWF VIP

Local time

Today, 14:30

Joined

Aug 29, 2005

Messages

8,262

• Dec 18, 2005

• #3

Thanks RG, just what I was looking for

 

RuralGuy

AWF VIP

Local time

Yesterday, 22:30

Joined

Jul 2, 2005

Messages

13,825

• Dec 18, 2005

• #4

Glad to be of assistance.