S
Shawn
Hi,
I just finished creating a pretty large database. To
search in that one, I set up a Form that was hooked to the
main table in the database. Someone would Fill in a field
and hit a find button that opened a report that was
attached to query that read in and found the criteria that
was entered in the form. I have a few problems with this
way: 1. The first record in the table is always changing
to whatever search criteria was entered into the form...to
by pass this I set up a dumby record 2. If someone wanted
to search with 2 criterias they could do this by hitting a
button that I already had set up, but this makes for a lot
of buttons, For Ex. Button for Search By Name, By ID, and
BY Name and ID. I'm creating a new database with many
fields for which search criteria can be entered. Is there
an easy way to setup a search? One maybe where there
could be like 10 fields and only one search button, and if
there is criteria in that field it reads it, and if there
isn't criteria it just disregards that field. And a way
to set it up where the first record won't always change???
Thank you,
Shawn
I just finished creating a pretty large database. To
search in that one, I set up a Form that was hooked to the
main table in the database. Someone would Fill in a field
and hit a find button that opened a report that was
attached to query that read in and found the criteria that
was entered in the form. I have a few problems with this
way: 1. The first record in the table is always changing
to whatever search criteria was entered into the form...to
by pass this I set up a dumby record 2. If someone wanted
to search with 2 criterias they could do this by hitting a
button that I already had set up, but this makes for a lot
of buttons, For Ex. Button for Search By Name, By ID, and
BY Name and ID. I'm creating a new database with many
fields for which search criteria can be entered. Is there
an easy way to setup a search? One maybe where there
could be like 10 fields and only one search button, and if
there is criteria in that field it reads it, and if there
isn't criteria it just disregards that field. And a way
to set it up where the first record won't always change???
Thank you,
Shawn