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>
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

welshgasman

Well-known Member
Joined
May 25, 2013
Messages
871
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.?
 

welshgasman

Well-known Member
Joined
May 25, 2013
Messages
871
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:

Watch MrExcel Video

Forum statistics

Threads
1,122,748
Messages
5,597,914
Members
414,190
Latest member
PuzzlerUK

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
Top