Need help on how to store value selected from combo box.

[seawave]

I have several combo boxes on my form for my users to select a defined value. The combo boxes are unbound and I dont know how to write code that will save the user's selection into the field on the table were I want to save the data. Ex: I have one combo box that has specify cities loaded for the user to pick. I select a city and tab to the next textbox on the form. I complete the data entry textboxes on the rest of the form and when I select the next blank records 2 things occur: (1) the textbox values are saved in a record on the table, but the combo box value
is not saved in table. (2) the textbox fields on the form are cleared of the current record when I select the next new record, but the combo box value remains on the form.
I hope I have explained this logically for you to help.
I am just starting to get back into using Access database and am having difficulty using coding.
Thank you for your time.
Seawave

 

[KenReay]

Hi

Are the text boxes bound?

If yes, why not just bind the combo boxes too?

If No, use whatever method you are using for the text boxes, to save the values from the combo boxes Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK