Access Form Question

  • Thread starter Thread starter Chris
  • Start date Start date
C

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
 
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.
Click to expand...

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.
 
I moved everything to the header now on Form open I can't see anything. The
form is blank even before running anything.
 
I moved everything to the header now on Form open I can't see anything.
The form is blank even before running anything.
Click to expand...

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