How to clear a bound form?

[patjones]

Hi:

I've got a form called "frmChecks" which is the form that loads automatically upon opening my database. frmChecks is bound to two different tables.

The problem is, I want it to open up completely cleared. I don't want it to actually display records until the user types a check or employee ID into the search box and clicks my search button.

I realize that I could just make this an unbound form and then assign the text boxes their values after the search has found a record to display, but I would like to find a way to clear a bound form first, before going the other route.

Any suggestions?

[Rabbit]

What about setting the form's record source to nothing or having it using a zero record query as the record source?

SELECT * FROM SomeTable WHERE 99 > 100;

[Rabbit]

Resuscribing .