T
tsison7
I have a table of customers and a table of account managers. Each customer
is assigned to an account manager. I want to set up a form where you can
choose a customer, but also want to be able to filter that form just for the
account manager who is logged in. Note that when the user signs in I assign
his identifier into a public function...getmyvariable().
I set up an option group. (1) show all (2) filtered but I am having trouble
filtering the combo box based on the option chosen. Am I going about this
the wrong way or is there a way to change the query of a combo box based on
that option group?
is assigned to an account manager. I want to set up a form where you can
choose a customer, but also want to be able to filter that form just for the
account manager who is logged in. Note that when the user signs in I assign
his identifier into a public function...getmyvariable().
I set up an option group. (1) show all (2) filtered but I am having trouble
filtering the combo box based on the option chosen. Am I going about this
the wrong way or is there a way to change the query of a combo box based on
that option group?