List box

J

jeremy0028

I want to creat a simple list box searh but dont know how to do it

Search Critera name of text box above list box

List box name is listbox12

Looks up the following information from the patient info table

Last Name
First Name
Social Security
Date of Birth

How to i link the search criteria to list box

Example i type the letter E in the search criteria for patients with
the last name staring with the letter E will appear in the list box

Please help
 
G

Guest

Hi Jeremy,

I can try sending a zipped sample, in Access 2000 format, to your indicated
e-mail address if you want me to do this. Post back and indicate if you want
this sample, but do not include your e-mail address, unless you obscure it
first.

If you want to avoid using VBA code, you must set the Multi Select property
for the list box to None. Otherwise, you'll need to use VBA code to loop
through the collection of selected records, and build the WHERE portion of
the SQL statement on-the-fly.

If you want to find a record and move to that record, you can use a combo
box as shown in this example:

Combo box to find a record
http://www.access.qbuilt.com/html/find_a_record.html

You could always convert this combo box into a list box when finished, and
it should continue to work, as long as the Multi Select property is set to
None.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

I want to creat a simple list box searh but dont know how to do it

Search Critera name of text box above list box

List box name is listbox12

Looks up the following information from the patient info table

Last Name
First Name
Social Security
Date of Birth

How to i link the search criteria to list box

Example i type the letter E in the search criteria for patients with
the last name staring with the letter E will appear in the list box

Please help
 
J

jeremy0028

Thank you very much downloaded the link which is running know exactly
what i wanted

Thank you very much :)
 
J

jeremy0028

Links are working know downloaded database thank you very much

Exactly what i wanted :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List Box search 4
A couple of list box problems - Please help! 11
Filter subform from combo unbound text box 3
Combo Box Problems 2
Search by first or last name 2
List Box Query - Forms 3
Search Date Range from text box with results in List Box 1
multi select list box in a form as a query parameter 3

Top