MainForm/SubForm Problem 1

[matrec]

I posted this question by mistake to the wrong forum, so I repeat it here:
I have a field named 'TransNo' in the MainForm. The subForm is in the Detail Section of the MainForm.

In the footer of the subForm I have another field called 'InvoiceID' and its Default Value is set to [Form]![subForm]![TransNo].

The problem is that, when I start filling the subForm with data, 'InvoiceID' remains blank for the first record. From the second record onwards everything is OK.

I have not managed to solve this problem, though I spent 3 hours trying all sorts of things.

Any hints to solve this irritating problem ?
Thanks

 

[lupins46]

How is the main form linked to the subform (what fields?)

 

[TheAceMan1]

How are ya matrec . . . . .

In the OnCurrent event of the main form try:

[blue]   Me!subFormName.Form.ReCalc[/blue]

See Ya! . . . . . .

 

[matrec]

Thank you both.
1. Lupins46 the field that links MainForm and subForm is OK.

2. TheAceMan1, you are absolutely right. Problem solved. Thank you.
Best rgds