Defined Field on Form

  • Thread starter Thread starter E
  • Start date Start date
E

E

I have a defined field on a form which is a combination of
two other fields. It will not write the defined value
back to the table, however it is visible on the form.
Does anyone know how to do this.

example:

[sample_id]=[station_id]&"-"&[sample_date]

Thanks for any and all help
 
It is bad practice to store calculated data in the tables
for two reasons; it wastes space and it can be difficult to
update should any of the components change. Keep the
component data only in the table then use controls as you
have done in forms and reports to show the calculated data.

Hope This Helps
Gerald Stanley MCSD
 
Back
Top