Populate forms

[Adrian Roberts]

Hi all
I am very new at access, what I have is a database in which I enter all my
data through a forms, when I need to search for a particular record I have
to display the record in a new form, when I do these searches I need to see
all the information on a client so instead of opening a new form can I enter
the search criteria then have it display in the main form. I have about 10
different search criteria and it seems pointless making 10 forms the same.
Thanks for any help
Ady

 

[John Vinson]

Hi all
I am very new at access, what I have is a database in which I enter all my
data through a forms, when I need to search for a particular record I have
to display the record in a new form, when I do these searches I need to see
all the information on a client so instead of opening a new form can I enter
the search criteria then have it display in the main form. I have about 10
different search criteria and it seems pointless making 10 forms the same.
Thanks for any help
Ady

Have you tried using the very powerful "Filter By Form" technique?
Open your data display form, and select Records... Filter by Form.

You can then put criteria in one, two, or ten controls on the form,
and Access will search for them.

John W. Vinson[MVP]

 

[Adrian Roberts]

Hi
Thanks for that I took a quick look and it may weel do the job, one of the
criteria I have is to find all additions to the database after a certain
date, would that work from this as well. I assume I can put buttons on the
page to do the filter by form as other people can use it but I wanted to
turn the toolbars off.

Thanks
Ady

 

[John Vinson]

Hi
Thanks for that I took a quick look and it may weel do the job, one of the
criteria I have is to find all additions to the database after a certain
date, would that work from this as well. I assume I can put buttons on the
page to do the filter by form as other people can use it but I wanted to
turn the toolbars off.

You can (see the other responses in this thread) program a form to do
this; and yes, you can put a criterion

#6/1/2006#

in the date-added field to see all additions. (Of course you do need a
date-added field in your table and appropriate methods to maintain
it).

John W. Vinson[MVP]