icemonster
Registered User.
- Local time
- Today, 03:11
- Joined
- Jan 30, 2010
- Messages
- 502
hi, i know i posted this already and sorry. this is really driving me crazy.
i have a listbox that has an sql for a rowsource. that listbox sql is compsed of records from different tables. now the listbox is on a form from a main table, what i want is, the listbox to filter to the current record for that form.
lets say, the main table is for clients and the other table is for their schedules.
now the schedule table has alot of info, so when i put it on the listbox, it will show all of the records, how do i get the listbox to limit the records for the current record on the form? thanks you.
i have a listbox that has an sql for a rowsource. that listbox sql is compsed of records from different tables. now the listbox is on a form from a main table, what i want is, the listbox to filter to the current record for that form.
lets say, the main table is for clients and the other table is for their schedules.
now the schedule table has alot of info, so when i put it on the listbox, it will show all of the records, how do i get the listbox to limit the records for the current record on the form? thanks you.