Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    8

    Unanswered: Bound/updateable controls

    Hi Guys,

    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.

    Thanks b.

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    Make & " " & Model AS Name
    is not updateable: access wont parse Name to regenerate Make & Model

    ...two text boxes. one each for Make & Model

    izy
    currently using SS 2008R2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •