Unanswered: Calling a Record ID from a Subform for Controlling a Listbox
I want a simple Listbox to display only the Cabinet records where the RecordID of the Cabinet Record matches the RecordID of the Space Subform. Because I'm on a subform, the usual syntax does not appear to be working (eg. [Forms]![SiteFrm]![SpacesFrm]![CabinetID]. I usually place this type of argument in the 'Criteria' Row of the Query that is the Listbox Record Source, but since it's on a Subform and not on the main form, it's not working. HELP!!
Thanks so much for responding to my question. I got a little help from a co-worker who reminded me that I just needed to Requery the List Boxes. My Argument was actually doing it's job. I'm such a numskull sometimes. Just a wannabe.
I will keep your code example for future tasks. It is much advanced of my capability. Thanks again!! Jim (Revixx)
[QUOTE][SIZE=1]Originally posted by Teddy
This is sort of a round about way of doing it, but you could programmatically add each value.