Arthur Fuller
fuller.artful at gmail.com
Tue Dec 1 08:42:02 CST 2009
I haven't seen this issue, but try substituting Now() and see what happens. Arthur On Tue, Dec 1, 2009 at 9:32 AM, jwcolby <jwcolby at colbyconsulting.com> wrote: > I am seeing an issue in a linked table where the default value is set to > date(). If I view the > table it displays #unknown for the value for the field that is supposed to > be using date() as the > default value - and the function Time as well for that matter. If I go > directly in the BE that does > not happen, and I can add a new record. So it is only in a linked table > that this is an issue. No > missing references. SP3 applied. > > This kinda looks like a missing reference but that is not the case. > > I am not finding this problem with a Google search. > > Has anyone seen this problem? > -- > John W. Colby > www.ColbyConsulting.com > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >