update a subform

[crowegreg]

I can't figure out how to get the subform requeried. With the attached DB, these are the instructions.
1. Open form frm_Menu_Reports_Variance
2. Select the command button Position Management Changes
3. For the Search Option, select Position ID
4. For the Position ID combo box, select any number
5. For the change type list box, select any item

After selecting the change type, you'll get the option to either view report or export report. Select view report.

When the subform is displayed, it will display the data from the previous selection, not the selection you have just made.

I've tried adding the following lines of code to cmdViewReport, but nothing worked.
me.frm_PM_Changes_subform_ID.Requery
Forms!frm_PM_Changes_subform_ID.Requery


Thanks for your assistance!!

 

[crowegreg]

I figured it out. Within the cmdViewReport, after CreateData, I needed these two lines of code.

Me.frm_PM_Changes_subform_ID.Form.RecordSource = strQry
Me.frm_PM_Changes_subform_ID.Form.Requery

 

[missinglinq]

...Start by renaming the controls so they have meaningful names. No one wants to try to figure out what combo9 or list11 really are...

And in three months that No one will include yourself!

Linq ;0)>