Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2008

    Unanswered: Tie combo box to ClientID

    Hello again..

    How would I go about using a combo box to only show medications belonging to a single client.?
    I have a combo box right now that lists all meds belonging to all clients.
    Im sure it's easy but how do I tie these together?



  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    You need a combobox with all patients names (I'm am old fashioned health care provider; I hate the term "client!") The concept is called "cascading comboboxes." If you search here or google using the term you'll get a gazillion hits! Here one tutorial on the subject:

    Cascading Combo/List Boxes - Microsoft Access / VBA insights
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Jan 2008
    Do I need cascading combo boxes?
    (is that where the results of one combo box is reliant on a choice made in another combo box)?

    I have the main Resident form which has a medication sub form.
    The combo box on the medication sub form should only show only those meds which the resident is taking.

    I confuse myself....


Posting Permissions

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