Great!! Thanks for your help. I love simple solutions :o)
"Rick Brandt" wrote:
[Quoted Text] > On Mon, 22 Dec 2008 09:36:19 -0800, Chris wrote:
>
> > I have a form that has a search capability. The user puts in the account
> > number and it sends a pass through query to a SQL Server to retrieve the
> > data. The data then populates the form by changing the forms source to
> > the query. If the query doesn't retrieve any data the form goes blank.
> > The text boxes and buttons all disappear and all you see if the
> > completely blank form.
> >
> > I need a way to test the query before the source changes so the form
> > doesn't go blank.
> >
> > Any ideas would be appreciated.
>
> In that circumstance (no data and no new records allowed) only the detail
> section of the form goes blank. Move your search tools into the Form
> header and they will show up even when the search finds no matches.
>
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com
>
|