Bound Form with no records

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

Guest

Hi,

I have a form that displays records from a table. This works fine, but what
I would like to do is on opening the form I would like to return no records
until a search criteria is specified.

I thought I could use the RecordSource and just leave it blank until the
search criteria had been entered.

Any ideas?
 
You could just initialize your search criteria to something you know will
never return a record e.g. userid = "MickeyMouse"

-Dorian
 
There are a number of ways to do this.
One is to have the form open to a new record. It will appear blank provided
you don't have any Default Values set. When you do the search, Undo the form
so the blank (new) record goes away before you position on the chosen record.
Use a different form to do the search before you open the form, and use the
OpenArogs argument of the OpenForm method to postion the form on the selected
record.
 
Back
Top