auto date subform not working but it works outside the form



I asked this yesterday but have more info. Unfortunately I cannot find my
question from yesterday to add to it.

I created a separate form and then copied (or dragged) it to a form to make
it a subform. One control has a date entry which is auto by using default
Date(). It works in the form version but not in the subform version. The
strange thing is that when I change from Now() to Date() in the default it
changes in both the form and subform versions with the one change in either.
Both work in the form version but not the subform version. Any idea why that
could happen? Thanks very much,

Jeanette Cunningham

Hi Fred,
This is strange enough to sound like some corruption in the combined form
that has both main form and subform.
Try this:
Remove the subform source object from the main form.
Create a copy of the main form and put the subform on the copy.
Now test how the default date works.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


Thanks Jeannette,
As it turns out I had (a while ago) linked the subform to the form using the
date and that was somehow messing up the results. Thanks very much for your
help as it caused me to delve deeper than I would have otherwise.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question