Warning Startup form problem

[Bugsy]

I recently asked a question about using a form to give a warning msg if an
event was happening on the day my db was opened. I believe 'Allen' kindly
supplied me with the necessary info and the form works fine if there is an
event on that day however if there are no events I get nothing at all and
would actually like another form/the switchboard to startup?/ I have tried
various if statements to no avail can anyone help please.

 

[Linq Adams via AccessMonster.com]

It would really help to see the code you're using to pop up this warning form.


--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com

 

[Bugsy]

Thx will try and post it up later today/tomorrow

 

[Bugsy]

Linq apologies for not getting back earlier but other work issues took
priority!! Here is the code I am using at the moment:

Private Sub Form_Open(Cancel As Integer)
If Me.Recordset.RecordCount = 0 Then
'MsgBox "No Events"
Cancel = True
End If
End Sub

The "Warning Form" works fine if there is an event on the date shown and it
also displays the "No Events" msg box if not.

However after clicking on the "OK" but to cancel the msg box I would like
the switchboard to open, at the moment I have to manually open the db again.
Any help would be appreciated.