I need some help in figuring out how to track selections from a combo
box that have not been selected.
Right now, in 'Form 1' the user will select an option from the list
in the combo box. This combo box is populated from 'Table 1'. When the
value is selected in 'Form 1" it is stored in 'Table 2'.
Right now, the contact information pulls from Table 2. Now, I'm trying
to ensure that certain information goes out to all entries in Table 1.
How will I track which values were not selected from Table 1 in Form 1
so that everyone can get the info?
I've tried querying multiple ways : my best luck was with finding
which entries were selected from Table 1 from the combo box.
I'm not reaching anywhere with trying to pull values in Table 1 that
haven't been selected in Table 2 as this gave me weird results
(thousands more than whats actually in form). Here I tried querying
the tables using a 'Name field' in Table 1 with a criteria of
<>Table2.Name .
Any suggestions?
box that have not been selected.
Right now, in 'Form 1' the user will select an option from the list
in the combo box. This combo box is populated from 'Table 1'. When the
value is selected in 'Form 1" it is stored in 'Table 2'.
Right now, the contact information pulls from Table 2. Now, I'm trying
to ensure that certain information goes out to all entries in Table 1.
How will I track which values were not selected from Table 1 in Form 1
so that everyone can get the info?
I've tried querying multiple ways : my best luck was with finding
which entries were selected from Table 1 from the combo box.
I'm not reaching anywhere with trying to pull values in Table 1 that
haven't been selected in Table 2 as this gave me weird results
(thousands more than whats actually in form). Here I tried querying
the tables using a 'Name field' in Table 1 with a criteria of
<>Table2.Name .
Any suggestions?