Can't get combobox to work when updating record

[Guest]

There are items in a field that are used many times therefore I would like to
make this field a combobox (Rowsource = SELECT DISTINCT
(chktran.Description) AS Expr1 FROM chktran ORDER BY chktran.Description
and control Source would = Description ) so when I select the Item in
combobox it would get selected and update record.
But I get message Control can't be edited; it's bound to
expression[description]

 

[fredg]

There are items in a field that are used many times therefore I would like to
make this field a combobox (Rowsource = SELECT DISTINCT
(chktran.Description) AS Expr1 FROM chktran ORDER BY chktran.Description
and control Source would = Description ) so when I select the Item in
combobox it would get selected and update record.
But I get message Control can't be edited; it's bound to
expression[description]

You can't bind a combo box whose record source is a Select Distinct
SQL.
Leave this combo unbound.

Add a regular text control bound to the field.
Code the AfterUpdate event of the combo box:

Me![BoundControl] = Me!ComboName

 

[Guest]

I had a security problem It works great.