List box

  • Thread starter Thread starter jeremy0028
  • Start date Start date
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
 
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
 
Thank you very much downloaded the link which is running know exactly
what i wanted

Thank you very much :)
 
Back
Top