Subform based on temp table not updating.

jknauft

I have a form that includes a subform which is based on a temptable. Everything works great when the form is first opened. When the user navigates through the records on the main form the subform is blank except on the first record that was viewed when the form was first opened. Any ideas? Thanks.

-Jon

MChilari

Hi Jon,

You might have wrote some code to insert the data in the temp table. you need to execute that code from the main form OnAfterGetCurrRecord.

EX:
CurrForm.SubformName.FORM.UpdateSalesLines("Document Type","No.");


Thanks