Subform Query

[Robby19]

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;
[TABLE="width: 500"]
<tbody>[TR]
[TD]uUserID[/TD]
[TD]uFirstName[/TD]
[TD]uLastName[/TD]
[TD]uEDIPI[/TD]
[TD]uRank[/TD]
[TD]uLastLogon[/TD]
[TD]uLogonCount[/TD]
[TD]uSecurityID[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]


And if 9 was selected in the combobox, it would show me this;
[TABLE="width: 500"]
<tbody>[TR]
[TD]uUserID[/TD]
[TD]uFirstName[/TD]
[TD]uLastName[/TD]
[TD]uEDIPI[/TD]
[TD]uRank[/TD]
[TD]uLastLogon[/TD]
[TD]uLogonCount[/TD]
[TD]uSecurityID[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]9[/TD]
[/TR]
</tbody>[/TABLE]

 

[welshgasman]

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.?

 

[Robby19]

How do I base the query on the value of the combobox?

 

[welshgasman]

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.

[/URL][/IMG]

HTH