My database contains a form which is based on a query of entity data.
The Re****ts form contains Entity information in addition to an unbound
date
field called EffDate.
EffDate has a Default Value of =Date() to display system date
The EffDate field is referred to in underlying queries of re****ts which
are
run by clicking a command button on the Re****ts form.The re****ts use both
the
EffDate info and Entity info to run.
The re****ts run fine when the EffDate field is defaulted to the system
date.
However, the users need to be able to enter other dates in EffDate field.
I have removed the =Date() default value from the EffDate field, but the
field will not allow other dates to be entered.
I checked all the EffDate field properties, there appear to be no
restrictions.
Baffled as to how to allow user to enter other dates in EffDate field.
Any help would be greatly appreciated!
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200812/1
