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..
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.