Thread: Bound/updateable controls
10-31-03, 03:31 #1Registered User
- Join Date
- Oct 2003
Unanswered: Bound/updateable controls
I have started to create a form with a combo box which holds the data from this query:
SELECT Make & " " & Model AS Name, CarID, Price, Predecessor, PredecessorID, IsPredecessor FROM tblCar;
The combobox only shows the fieldName there are text boxes below that are bound to the combobox show most of the other data. Currently these cannot be updated by the user, i get this error: control cant be updated: its bound to expression ......
How can i make these textboxes updateable so that they update the recordset?
Also: i want to display Predecessor in a combobox, but predecessor is related to a CarID, if the IsPredecessor of a car is set to yes, the car can be a predecessor of another car. I would like to show all possible predecessors in the combo box and have this update the database when changed too.
Any help would be great with this one.
10-31-03, 04:42 #2Cavalier King Charles
- Join Date
- Dec 2002
- Préverenges, Switzerland
Make & " " & Model AS Name
is not updateable: access wont parse Name to regenerate Make & Model
...two text boxes. one each for Make & Model
izycurrently using SS 2008R2