Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    67

    Unanswered: Adding multiple selections from a combo box

    I have a form where one of the fields is "Medications". I have created a database for Medications. "DrugID, DrugName, DrugDir" I want to select as many medications from the combo box and automatically update the "Med..." field in the form. I also need to be able to print out all the information on a report.

    Second-?: If a combo box has a field "Memo", can I update another "memo" field in a different table with the info in the first Memo field?

    Thanks...

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    One field on one form can only hold one piece of data. If you need to have more than one piece of data, you will have to use a list box or a sub form.

    You can copy data between tables (including memos) using an update or an insert query.

Posting Permissions

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