Auto complete

[Canary Yellow]

I have a table which contains:-

Employee ID Full name
AD Alison Doody
AM Ape Monkey
PT Pet Tepee

etc
etc

In a form i want to be able to select the Employee ID and then next to it in another box the full name appears.

I've looked at other auto complete post, but nothing seems to match what i want to do.
Can anyone help?

 

[zdog]

Hi Canary,
I would use a form and a subform. The form would have a combobox, the source for which would be the ID field from the table. The subform would have a textbox that will be updated based on the selection in the combobox on the main form. If you need further help with setting this up let me know
ZDog

P.S. Whats up with the font????

 

[zdog]

Heres a sample db for you

 

[Canary Yellow]

thanks but,

do you have the example in A97?

I followed your previous advise, but am having a little trouble getting it to work, so the example would be MUCH appreciated

Canary

 

[zdog]

Canary, In the sample db I am using only 1 form and not 2 like I suggested earlier, I realized that one form was sufficient. I've converted the db to 97 hope it works.

 

[Canary Yellow]

thanks again

I have to go home now as am working 8am-4pm, but i will look at it first thing in the morning.

I have opened it and it look promising though

Many thanks

Canary