Passing a Date from Form to Sub-form

[ALNG]

I have a form where a date is keyed. This date is to be passed to records in a table through a sub-form. When the date is passed, it displays as a number instead of a date, even though the field is formatted as Short Date.

Example: Date keyed in form is 01/01/2006. Number passed is 38718 (the serial number for that date).

How do I get the date to be displayed and stored in the sub-form (and table) as a date?

 

[misscrf]

check the format for that field in the table and in the form control that shows the field.

misscrf

It is never too late to become what you could have been ~ George Eliot