Blank Form Fields

Hi All,

Another simple question, how do I make it so when I open
my main form that it doesn't show up the first record in
my tables.

I want to have all fields in the form blank to start
with, then click the search button to bring up the
required information.

Basically all I want is for the fields in the form start
off blank until a search is done.

Thankyou all,
Eli

That might be a little tricky coz a form object actually is designed to view the table object in a different manner.

What I suggest is, Design a separate SEARCH FORM not connected to any table and CODE a variable that shall then pick up entries and create a search query to access relevant data on your tables.

On Sun, 30 May 2004 21:44:23 -0700, "Eli"
wrote:

Hi All,

Another simple question, how do I make it so when I open
my main form that it doesn't show up the first record in
my tables.

I want to have all fields in the form blank to start
with, then click the search button to bring up the
required information.

Basically all I want is for the fields in the form start
off blank until a search is done.

Do you want to just *view* the data, or actually edit it once you've
found it? Do you want the user to be able to insert new records in the
table?

This can be done a couple of ways, but which way is best depends on
what you want to do with the data once it's been found!

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

-----Original Message-----
On Sun, 30 May 2004 21:44:23 -0700, "Eli"
wrote:

Hi All,

Another simple question, how do I make it so when I
open
my main form that it doesn't show up the first record
in
my tables.

I want to have all fields in the form blank to start
with, then click the search button to bring up the
required information.

Basically all I want is for the fields in the form
start
off blank until a search is done.

Do you want to just *view* the data, or actually edit it
once you've
found it? Do you want the user to be able to insert new
records in the
table?

This can be done a couple of ways, but which way is best
depends on
what you want to do with the data once it's been found!

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
.


I have setup a form to display all table fields and have
placed a search button at the top of the form. You click
the search button and type the name of the computer and
up comes all its information.

The only problem is that the fields all have information
in them on the form when you first enter the form. I
would like them to be blank. The form won't be edited it
is purely for searching.

Thanks