Autofill a Search Bar???

M

MarieG

Hi,

I don't know if I have the correct terminology, but... I'm making a form
for my users to look up a customer by name.. I want there to be a dropdown
box that, when you begin typing the name, the box shows possible matches
below it. Then the more letters you type, the more filtered the data below
becomes.. ?? Is this possible?? I've tried looking online, but I think I
have the terminolgy all wrong.. ??
Hope that made sense.. and thanks so much!!!!
 
J

John W. Vinson

Hi,

I don't know if I have the correct terminology, but... I'm making a form
for my users to look up a customer by name.. I want there to be a dropdown
box that, when you begin typing the name, the box shows possible matches
below it. Then the more letters you type, the more filtered the data below
becomes.. ?? Is this possible?? I've tried looking online, but I think I
have the terminolgy all wrong.. ??
Hope that made sense.. and thanks so much!!!!
Click to expand...

This is the default behavior of a Combo Box (provided the first visible field
in the combo is the name).

You don't need ANY code or anything fancy - it's built right in.

If you'll describe the structure of your table (fieldnames and datatypes)
we'll be able to specifically say how to set up the combo.
 
M

MarieG

Thanks John..

Here is the SQL view of the Query that makes the table. Also, this table
will have something like 60K or more entries..


SELECT "OGA" AS [Database],
[dbo_uvPatientDemographics-TMC002-OGA].PatientFirst,
[dbo_uvPatientDemographics-TMC002-OGA].PatientLast,
[dbo_uvPatientDemographics-TMC002-OGA].PatientFullName,
[dbo_uvPatientDemographics-TMC002-OGA].PatientSSN,
[dbo_uvPatientDemographics-TMC002-OGA].PatientBirthDate,
[dbo_uvPatientDemographics-TMC002-OGA].GuarantorFirst,
[dbo_uvPatientDemographics-TMC002-OGA].GuarantorLast,
[dbo_uvPatientDemographics-TMC002-OGA].GuarantorFullName,
[dbo_uvPatientDemographics-TMC002-OGA].GuarantorSSN,
[dbo_uvPatientDemographics-TMC002-OGA].GuarantorBirthDate,
[dbo_uvPatientDemographics-TMC002-OGA].DoctorListName INTO [Patient-Guarantor
Lookup Table]
FROM [dbo_uvPatientDemographics-TMC002-OGA];

Thanks!!!
 
J

John W. Vinson

Thanks John..

Here is the SQL view of the Query that makes the table. Also, this table
will have something like 60K or more entries..
Click to expand...

That's a lot for a combo box (limited to 64k records)... you may want to use
Allen Browne's tip:

http://allenbrowne.com/ser-32.html

I still don't understand the context. Creating a table has no particular
bearing on using a combo box... does your table have a Primary Key (the SSN
perhaps?) If not it probably should.
 
G

Guest

MarieG said:
Hi,

I don't know if I have the correct terminology, but... I'm making a
form
for my users to look up a customer by name.. I want there to be a
dropdown
box that, when you begin typing the name, the box shows possible matches
below it. Then the more letters you type, the more filtered the data
below
becomes.. ?? Is this possible?? I've tried looking online, but I think
I
have the terminolgy all wrong.. ??
Hope that made sense.. and thanks so much!!!!
Click to expand...
 
M

MarieG

Thanks John! I looked at the link you provided.. that would be perfect,
but I don't know where to put some of the code. Step one says to paste the
code into the General Declarations of the Combo?? I didn't see a field
called that in the properties box.
 
J

John W. Vinson

Thanks John! I looked at the link you provided.. that would be perfect,
but I don't know where to put some of the code. Step one says to paste the
code into the General Declarations of the Combo?? I didn't see a field
called that in the properties box.
Click to expand...

General Declarations means at the very top of the module, above the first
Private/Public Sub line.
 
Top