open a form at start up only if it holds records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a a form that holds records if the date criteria is met else there
will be no records.

How can i make this form open up at start up if it holds records only.

help is appreciated.
 
Richard --

I'm a bit confuesed by what you're after here but I have a few suggestions
to offer:

First, the confusing part to me:
"At startup" I assume means at the startup of the database. If this is the
case where does the form get the date criteria that will determine if the
form has records or not?

Now for suggestions:
Try using the Form Open event of the form to check and see if the recordset
for the form is empty or not. If the recordset is empty then close the form.

HTH
 
hi darrep,

you are right in that i want to open the form on start of the database. the
idea behind it is that we have policies for clients where the acceptance
terms run out, so i have created a qry to highlight these within the next 7
days. what i want is for the form to open automatically if there are records
present to prevent human error in not checking.

i will try the open form event but would be grateful if you would let me
know what i need to do here.

thanks for your help

richard
 
Back
Top