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

    Unanswered: How can I only show a few records?

    If you look at the attached pic you sill see what I am working on.
    Med Incidents. Resident forgets or refuses... etc
    So how can I limit the Medication dropdown to only show the records that belong to that client?
    As it is I have to scroll around looking for the med..

    Any help would be gratefully received!!

    Attached Thumbnails Attached Thumbnails New Picture (1).bmp  

  2. #2
    Join Date
    Oct 2009
    a dropdown (or combobox) is initially generically set up to look at a table field(s)

    if you go to the combobox's property it will show the record source as that table. you can open this up pressing the ... and expose the actual query of that table - - and in here you can add a criteria to this query that calls a value from a control box in the form.

Posting Permissions

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