CODEWITHSUNDEEP
sqlms-accessms-access-2010
user2650277
user2650277

Reputation: 6739

Control cannot be edited

I have a sale form with a subform , however i cannot choose data from my combo box.I get the following

Control cannot be edited , it is bound to autonumber field Item_ID

Below is the SQL

SELECT [tblStockItem].[Stock_ID], [tblStockItem].[Item_ID] FROM tblStockItem ORDER BY [Item_ID];

Upvotes: 1

Views: 306

Answers (1)

HansUp
HansUp

Reputation: 97131

It sounds like the purpose of the combo box is to select data, not change stored values. In that case, make it an unbound control --- meaning leave its Control Source property empty.

Then you can do your data selection based on the combo's value without Access complaining about changes to that autonumber field.

Upvotes: 2

Related Questions