Blank Form Fields

  • Thread starter Thread starter Eli
  • Start date Start date
E

Eli

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

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!
 
-----Original Message-----


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!


.
Click to expand...

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
 
Back
Top