Trouble with SELECT Query

[Bob Richardson]

My form uses a combo box with the data that's put into it based on a Query.
From a table with two columns, Year and Data, I select only the Data where
Year=Current_year. The correct data is displayed in the combo box. HOWEVER,
when the user clicks on a choice, that choice is not shown, or saved in the
data base. The field remains blank.

Any ideas what might be happening. I use this approach on other fields with
no problem.

 

[fredg]

My form uses a combo box with the data that's put into it based on a Query.
From a table with two columns, Year and Data, I select only the Data where
Year=Current_year. The correct data is displayed in the combo box. HOWEVER,
when the user clicks on a choice, that choice is not shown, or saved in the
data base. The field remains blank.

Any ideas what might be happening. I use this approach on other fields with
no problem.

Is the Combo Box bound to a field in the table?
Is the bound column the correct one?

Do you really have a field named "Year"?

Year is a reserved Access/VBA/Jet word and should not be used as a
field name.
See the Microsoft KnowledgeBase article for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
321266 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'