Expresions in forms not filling in table

  • Thread starter Thread starter jpulliam
  • Start date Start date
J

jpulliam

I have a form that uses some expresions to fill in some of the fiel
boxes, such as date and user name. They work fine on the form, but th
fields in the table assciated with the form do not fill in. What simpl
thing am I missing.

Ji
 
I have a form that uses some expresions to fill in some of the field
boxes, such as date and user name. They work fine on the form, but the
fields in the table assciated with the form do not fill in. What simple
thing am I missing.
Click to expand...

The fact that a Form control can have a table field as a control
source, *or* an expression - it can't be both.

Normally one would not store a value which can be calculated in a
Table at all. What you might want to do in this case is set the
Default Value properties of these two textboxes to =Date() and to the
user name expression instead of the Control Source properties; that
way when you add a new record these controls will default to the
desired values. If you don't want the user changing them, set the
Locked property to true.
 
Back
Top