Store result of calc in table field

  • Thread starter Thread starter Marie
  • Start date Start date
M

Marie

Wayne,
I don't have any working macros. I have never used macros;
however, was trying to per KB 209172. The AutoFill.... is
a function.

In a nutshell here is what I need to do. My table has a
fldDyeTrackingNum field. On my form I trim two fields to
get this result: =Trim([fldReqFormNumber] & "-" &
[fldResCode]). How do I get this value to store in the
fldDyeTrackingNum in my tblSamples? My understanding is
that it won't store because it is the result of a
calculation.

Thanks for your help.
Wilma
 
How about in the form's code module you do:
me!fldDyeTrackingNum = Trim([fldReqFormNumber] & "-" &
[fldResCode]). I would not use a macro for this.
 
Back
Top