web access 2010 database - main nav, form droplist, requery subform need help

[ninjamustang]

hello,



I have a main form, in that i have a subform (frmAssignTo) with a dropdown list, when selected, it should filter and requery a subform (frmAssignToSubform) based on what i selected.

I followed a tempvars guide from http://dmoffat.wordpress.com/2011/10...ces-web-forms/
but still couldn't figure it out after hours of reading about tempvars.

I'm attaching my file. Please point out what I did wrong. thanks so much.

[ninjamustang]

I figured it out after reading the entire features of web access db 2010 and understood what each function does.

So here is the solution
Main Form
droplist, say name is cboComboSelect

After update, SeTempVar, name = txtComobo, exp = [cboComboSelect], name = MySubForm

Subform, name it MySubForm
This is the detail of your records. So make a query, then go to the field (eg: Company), in that Company, in the Criteria, put in [SeTempVars]![cboComboSelect]

Now if you just open that query, everything is emptied which is correct. Now open the Main Form, select value and it will filter correctly.