Subforms

[Tammy]

I have a form with a subform. The subform is based on a
temporary table which is deleted each time the main form
is opened. The problem is the fields in the subform have
the error #deleted# each time I open the main form for
the first time, I have to open the main form twice. Does
anyone know how to correct this problem?

Thanks for your help in advance!

 

[Guest]

I figured out that I just had to requery the subform