Hello again!
I am trying to build a form that will show the User Permissions level, uSecurityID, based off a combo box (dropdown) selection.
I have a SubForm "sf_qry_UserPermissions," a Form "FrmUserPermissions," and a Query "QryUserPermissions".
The subform pulls from the query just like I want it to. My problem is getting a ComboBox on the SubForm to automatically update the results of the SubForm/Qry.
Help would be greatly appreciated!
For example, if 2 was selected in the combobox, it would show me this;
<tbody>
</tbody>
And if 9 was selected in the combobox, it would show me this;
<tbody>
</tbody>
I am trying to build a form that will show the User Permissions level, uSecurityID, based off a combo box (dropdown) selection.
I have a SubForm "sf_qry_UserPermissions," a Form "FrmUserPermissions," and a Query "QryUserPermissions".
The subform pulls from the query just like I want it to. My problem is getting a ComboBox on the SubForm to automatically update the results of the SubForm/Qry.
Help would be greatly appreciated!
For example, if 2 was selected in the combobox, it would show me this;
uUserID | uFirstName | uLastName | uEDIPI | uRank | uLastLogon | uLogonCount | uSecurityID |
2 | ... | ... | ... | ... | ... | ... | 2 |
10 | ... | ... | ... | ... | ... | ... | 2 |
<tbody>
</tbody>
And if 9 was selected in the combobox, it would show me this;
uUserID | uFirstName | uLastName | uEDIPI | uRank | uLastLogon | uLogonCount | uSecurityID |
1 | ... | ... | ... | ... | ... | ... | 9 |
4 | ... | ... | ... | ... | ... | ... | 9 |
<tbody>
</tbody>