Look up list when doing a FIND RECORD

[valkyry]

Hi,
I'm trying to find a way where I can create a look-up list.

Here's the scenario:
I want to look-up a Customer and don't know the full name so I want to look-up a list of Customers that start with the letters: "Ang"

Then I would like to see a list that comes up that shows all the Customers we have in the database that starts with "Ang", seeing something like:

Angela test
Angelo weoiut
Angie mwelkwje
and so

And then once I determined which Customer it is, select the Customer from the look-up list and select "Angelo weoiut".

Hope this made sense a you programmers out, there's gotta be a way!! PLEASE HELP!

I'm only a technial user so I need the code!

Thanks in advance!

 

[donnadee]

Can you use a subform on top of a switchboard button?

For instance, we have linked tables: table 1, table 2, table 3.

We created a form that allows users to enter a name like Smith* at the top and it finds all the Smiths, Smithsonians, etc., and lists items like their Full Name, Address, Phone, and etc., at the bottom in a subform.

Users can double click on the client's name at the bottom and it goes into that client's record.

You should be able to get sample code from the sample databases like Northwind.mdb for the basic schematics. Sorry I can't give you more specific info.

 

[valkyry]

I must have wrote it wrong. I know you can do a find and get the set of records where it's like smith*, BUT you can see the whole list of the smith* in a look-up list and then select smithsonian from that list to see the information like their address, etc . . .

I know you can either click next to go to the next smith* record and then the next one and so on but that's not what I'm looking for.

At least if I understand what your suggesting correctly. Anyway, in the Northwind.mdb, it does not have what I'm looking for.

Go to the Orders menu in the Northwind.mdb, say you want to look-up a Bill To and you don't know the whole spelling, so you want to see all the Bill To that begins with smith* (using your example).

It does exactly what I'm saying in this thread and that's not what I'm looking for. Just so you can see what I'm talking about.

I need a programmer that could tell me how to write the code to do an actual look-up list.

It can look like what you might see in a Combo Box or a List Box or a Value List, but from that, when you do a find for a smith*, the Combo Box, or List Box, or Value List will show ONLY names that start with smith and then select from that list the smith I want.

Hope that clears up what I was actually looking for. Or I just don't know how to do it in the Northwind.mdb.