Adding a value to a field that is not on a form

[paduanow]

I open a form that has 3 fields

I have a "save" command button. On Click, I want to add "IC" to a field
that is not displayed on the form before I go to the next record. The user
is not aware of this value and unique by the form they select. The form they
select determines the type of transaction and sets a transaction code the
requested that is used later.


I tried Form![formname]![fieldname].Value = "IC"
Unless the fieldname is on the form this does not work.
I tried [tablename]![fieldname].Value = "IC"
and this did not work either.

 

[Dorian]

On the form, add a control bound to the column and make the visible property
= false.
Then you can set the fields value using:
Me![Hiddenfieldname] = "IC"
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".