Some basic Form related questions...

[CodeGunnerLev1]

Hey Guys

How r ya? hey I am new in this thing and I think this is awesome place
to be in....

Say I want to ask you guys a question.
I need to know how can I produce a search button (search function) when
making a form. Say if I have a table containing ID, First Name, Last
Name, and email address then what I want it to do is to search the
table based on where the user wanting it to be...

you see I have two field, one is a normal text field and the other one
is drop down field containing categories of the above table. (ie. ID,
first name, last name, email) This is how it goes, the user is putting
say an ID and then using the drop down option, chooses the category
that she wants it to search in. and then press search...
How do we do that? I tried using the wizard but it then uses macro
which I don't really understand...
It is MS Office 2007.

Thank you kindly for your help guys...

[Allen Browne]

If you are using the new Access 2007, there is a Search box in the
horizontal scrollbar at the foot of your datasheet. You can just type a
value in there, and Access will find it in any field.

If you want to proceed with the approach you suggested (i.e. a combo to
select the field to look in, and a text box to enter the value to find),
see:
Find as you type
at:
http://allenbrowne.com/AppFindAsUType.html
You can download the zip file from that page, copy the combo and text box
onto your form, set one property, and it works from there.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"CodeGunnerLev1" <er********@gmail.comwrote in message
news:11**********************@m58g2000cwm.googlegr oups.com...

Hey Guys

How r ya? hey I am new in this thing and I think this is awesome place
to be in....

Say I want to ask you guys a question.
I need to know how can I produce a search button (search function) when
making a form. Say if I have a table containing ID, First Name, Last
Name, and email address then what I want it to do is to search the
table based on where the user wanting it to be...

you see I have two field, one is a normal text field and the other one
is drop down field containing categories of the above table. (ie. ID,
first name, last name, email) This is how it goes, the user is putting
say an ID and then using the drop down option, chooses the category
that she wants it to search in. and then press search...
How do we do that? I tried using the wizard but it then uses macro
which I don't really understand...
It is MS Office 2007.

Thank you kindly for your help guys...