Results 1 to 2 of 2

Thread: Combo Boxes

  1. Oct 20th, 2000, 07:43 AM #1
    MattJH
    MattJH is offline

    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
    Reply With Quote Reply With Quote
  2. Oct 20th, 2000, 07:45 AM #2
    sebs
    sebs is offline
    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.
    http://fcx.org/profile/sebs
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width