I have a form that has a Tab Control on it. On one of the tab control
pages, there are only 3 pages, is a combo box based on a field called
departments in a table.
When the user selects one of the departments from the combo box I want a
sub-form to open on the tab control page based on the department
selected.
The sub-form is based on a query that pulls all employee data, so if a
user selects admissions, I want the subform to open and only display
records for the admissions depart.
I can get the sub-form to open and display all the records, but I can
not figure out how to make it display only the records I want.
How would I do this?
Thanks in advance for any help!
Michael Charney
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!