combo box to fill 3 fields on form

[Teebird]

I have the fields City, State and Postcode in my Member's table. My Member's form has the same 3 fields.

I have the CityLookup table which contains the City name and relevant State and Postcode.

I want my users to be able to either select from the combo dropdown list to select a City or start typing the name and the name will be autofilled from the list - then the correct City name, State and Poscode will automatically fill the fields on my form.

i have looked at a number of combo box methods and can not get one to work for me.

Any help would be appreciated.

 

[MStef]

Hello Teebird!

Look at "DemoComboBA2000.mdb"
The firs column in combo box is column 0.

 

[Teebird]

Many thanks for your reply. This is sort of what I want.

But when I select the City and the other 2 fields fill automatically, and then I close my form, the data is not saved. Also if I select a City from the list and then move onto the next record, the value I selected is displayed in the other records changing what was previously there.

 

[MStef]

Link the fields from form to the fields in table,
(your form must be linked on the table if you want to save a record).
On Current event put:
Me.ComboName = ""

 

[ansentry]

Teebird,
I answered the same question for you HERE

May I suggest that you don't post the same question twice.

 

[Teebird]

"From the top of the country to the bottom"

Thanks for your reply Ansentry. My 1st post was attached to the end of another post "How to populate a form from a combo box " that I found referring to combo boxes yesterday at 4.44pm. As I was waiting for a reply and the post did not quite meet what I am trying to do - I posted my own post "combo box to fill 3 fields on form" at 5.07pm. Your response to the 1st post was at 5.43pm and to my post at 10.05pm. My sincere apologies if you are of the opion that I posted twice.

Anyway now that I have grovelled - moving on to the task at hand....I thank you very much for your example and today I will try to work it into what I am trying to do. I may post my database in a simple form so you can see what I am trying to do (see how I go as I will be knee deep in concrete for most of the day).
Tee.