Results 1 to 2 of 2

Thread: Combo Boxes

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 2000
    Location
    Chesterfield, UK
    Posts
    298
    I'm writing a database in Access 97.

    I have a form "frmOrders" and a subform "frmOrdersSubform", within my subform I have a combo box that gets it's records via a select query from a different table "tblProducts"

    Now, when I select a particular value from the combo box I would like it to be removed, but, only from the current record.

    How????

    Thanks

  2. #2
    Frenzied Member sebs's Avatar
    Join Date
    Sep 2000
    Location
    Aylmer,Qc
    Posts
    1,606
    Redo your query with the condition :

    where id <> the one that you want to remove.

Posting Permissions

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



Click Here to Expand Forum to Full Width