Defined Field on Form

[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

 

[Gerald Stanley]

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