Combo box not working 2

[mypeljo]

I have got something wrong with my combo box.I have tried to build a combo box to choose the city for each contact but i fail to do that.When i choose the city from the combo box in the form, it is not saved and also all the other contacts get the same city as a default.I see i get the things wrong and i need a help. Can you help me build a regular combo box for choosing and saving the choice in the form.

The raw source of the combo box is the following:
SELECT [TblCity].[CityID], [TblCity].[CityName] FROM TblCity;

I can see the choices in the combo box but my form cannot save the choice.Can you help me ?

 

[MajP]

Need to know
1) What is the controlsource of the combobox?
2) What is the bound column of the combobox?
3) What is the field type of the control source?
4) Is the form bound to an updateable query?
5) What is the recordsource for the form?

 

[missinglinq]

.When i choose the city from the combo box in the form, it is not saved and also all the other contacts get the same city as a default.

I answered this for the OP elsewhere on the net. MajP's question #1 holds the answer! The problem was that the combobox was not bound to a field in the underlying table. Fixing this solved the problem.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[dhookom]

Thanks (and stars) to both MajP and missinglinq for resolving this thread. It's too bad the OP didn't respond.

Duane
Hook'D on Access
MS Access MVP