Refresh a subform

[Joe Cilinceon]

I'm having problems getting a subform to refresh. The main form's text boxes
are filled based on a selection made from a combo box. I then have and
append query in the After Update for the combo box that should fill the
subform underlying table. The table for the subfrom is an empty temp table.
The table is updating but the subform won't show the data. Any suggestions
would be appreciated.

 

[Jeff Boyce]

Joe

If your subform is not linked (parent-child) to your main form (and maybe
even if it is), have you tried requerying the subform once the main form
data has been saved?

Regards

Jeff Boyce
<Office/Access MVP>

 

[Joe Cilinceon]

Thanks Jeff I got it working I lost the query the main form was built on.