Access Form Question

[Chris]

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.

Thanks,

-Chris

 

[Rick Brandt]

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.

 

[Chris]

Great!! Thanks for your help. I love simple solutions )

 

[Chris]

I moved everything to the header now on Form open I can't see anything. The
form is blank even before running anything.

 

[Rick Brandt]

I moved everything to the header now on Form open I can't see anything.
The form is blank even before running anything.

Did you use the "Form Header" or the "Page Header"? Forms have both, but
the Page Header is only for printing.