Macro error

[DDIC]

I have a field on a form that I want to set the value of that field to the value of another field I have on the same form. The Macro is set up like this:

Item [Material]
Expression =[Forms]![Master Form]![MaterialType]

Error message is: You may have entered an operand without an operator.

This same set up works for my heat treat number field, and works if I take out the letters in my material type(4140L80 to 4140) but I need to keep that L80 in there. Anybody have this problem before, please help.

Thanks
Rusty

 

[jfgambit]

On the AfterUpdate Event of the MaterialType add the following:

me.Material = me.MaterialType

 

[DDIC]

Thanks,jfgambit


I'll try this Monday, I am on vacation.

Thanks