So I tried that, in it did not work so perhaps more details will help. We have a ticket tracking database for when a service request is called in. Those get entered into the ticket form. The "pool name" field is a combo box that is populated by the name of each pool. Each pool has its own record...
I have a form called "Ticket Form". It has a combo box field called "Pool_Name". This combo box is populated with records from a table "Pool Info Table" and the field "Pool Name." I have a second form "Poll Info Form" that is based on the data in the "Pool Info Table".
When I have a record open...