Can't get combobox to work when updating record

  • Thread starter Thread starter Guest
  • Start date Start date
G

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]
 
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]
Click to expand...

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
 
Back
Top