Hi Vision G

I understand that DATE is the control source for your DATE field on your subform. Is the text box name also "DATE"? If so, I would change the name of the text box to "TextDate" and keep the control source as DATE.

Then try =[9_PARADOSEIS].[Form]![TextDate]

I have had the same type of problems if I have the control source and the text box name identical.


D. Bartelt

Try this:

=Forms!2_ERGA!9_PARADOSEIS!DATE
or
=Forms!2_ERGA!9_PARADOSEIS!DATE.value