Update a subform

[crowegreg]

On a form, I have a subform which is based on a query. The user makes a selection on the form, the query is run, and the sub-form is set to visible.



I allow the user to re-select without exiting the form. If the user re-selects, I set the sub-form visible to false. After the user makes the selection, the query is run, but when the sub-form is visible, it contains the previous query results.

In my testing, before I set the sub-form to visible again, I've tried this code:
me.frm_PM_Changes_subform_ID.Requery

But it doesn't make any changes on the sub-form.

Thanks in advance for your help!!

[June7]

What do you mean 'the query is run'. Should requery the subform, not 'run' the query.

Post code or db for analysis.

[crowegreg]

Within the attached DB, forms in question are frm_PM_Changes & frm_PM_Changes_subform_ID

You'll need to open frm_Menu_Reports_Variance to properly open frm_PM_Changes.

[orange]

I tried running your database.

Get errors for missing/misspelled Reports.

Which buttons are we suppose to click to see the issue?

[crowegreg]

1. Open form frm_Menu_Reports_Variance
2. Select Position Management Changes
3. Search option, Position ID
4. From the Position ID drop down, select one of the numbers
5. From the Change Type list box, select any of the options
6. Click on view report

The query that this subform uses is not being executed before this subform is visible

Thanks

[crowegreg]

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


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

[orange]

Glad you have it working.