Hello All,



I have created a form with a lot of variables based on the selection of the Position and the Department.

As you see in the screen shot if the Selection is made of SPP for Position and External AD for Department I would want the "External AD" Append Querie to run.

However if Position is SPP and Department is Service I would want the "Service SPP" Append to run.

Each breakdown gets submitted to a different table for proper data management. I have 21 different departments and about 8 different positions. I need to set it in a way that when the selections are made the proper append querie will run when the Track button is clicked.

Any help with this? Thanks