Subform Query

Robby19

Board Regular
Joined
Mar 19, 2018
Messages
227
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;
uUserIDuFirstNameuLastNameuEDIPIuRankuLastLogonuLogonCountuSecurityID
2..................2
10..................2

<tbody>
</tbody>


And if 9 was selected in the combobox, it would show me this;
uUserIDuFirstNameuLastNameuEDIPIuRankuLastLogonuLogonCountuSecurityID
1..................9
4..................9

<tbody>
</tbody>
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Base the query on the value of the combobox?
On afterupdate of combo, requery the subform

Or link the subform to the combo and that will do it all for you.?
 
Upvote 0
In the query designer use Build for the criteria and then select form and control.
That will make it work only for that form then though.

The other way would be link combo to subnform. That way the query is not affected by any form controls?

In this pic I have a combo that selects all the records in a table that match in the Caller field.
Exactly what you a
re trying to achieve.
cbo%20linked%20subform_zpssnocxicj.png
[/URL][/IMG]

HTH
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,194
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top