update subform based upon parent form

Disgruntled · March 24th, 2010, 06:47 PM

In Access 2007, i have a form that has a combo control (or 2). Also on the form is a subform that takes it Record Source from a table tbl_tempSched

On my main form, i collect properties that will create tbl_tempSched

Code:

SELECT some-values INTO tbl_tempSched FROM some-table WHERE something ORDER BY some-field;

When this gets executed, i also want to update my subform as it will now have new data based upon tbl_tempSched.

How can i do this? I tried

Code:

sub_MySubForm.Requery

but that did not work.

Thanks for the help.