Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    79

    Unanswered: Update table from combo box selection

    I have 2 combo boxes, one for shipper, one for consignee (both bound to tblShipCons). I also have an option group for user to select which one (shipper or consignee) should be the bill to number. I don't know how to get the bill to number populated in the table(tblInvoice). It was suggested to me to use an SQL statement to update the table but the record does not exist yet. If I try to cursor into the subform (combo box and option group are not in subform) to allow the write of the record, I get the error 'You cannot add or change a record because a related record is required in table 'tblCustomers', which leads me to believe that the record cannot be written without some value in BillToNumber.

  2. #2
    Join Date
    Mar 2004
    Posts
    79

    Red face

    Please help. I'm not getting any responses which means it's either way easy or I'm not explaining very good. Please let me know which.

  3. #3
    Join Date
    Feb 2004
    Posts
    22
    If the invoice record does not exist yet, then you have to use an INSERT INTO query.

    Jack

Posting Permissions

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