RE: open a form at start up only if it holds records
From: richard harris (richardharris_at_discussions.microsoft.com)
Date: 03/19/05
- Next message: Luke_29_UK: "Calculate a running sum in a form"
- Previous message: michel: "Re: I am trying to calculate values in a form based on the values of 4 subforms"
- In reply to: darrep: "RE: open a form at start up only if it holds records"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 19 Mar 2005 01:23:02 -0800
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
"darrep" wrote:
> 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
>
> "richard harris" wrote:
>
> > 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.
- Next message: Luke_29_UK: "Calculate a running sum in a form"
- Previous message: michel: "Re: I am trying to calculate values in a form based on the values of 4 subforms"
- In reply to: darrep: "RE: open a form at start up only if it holds records"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
