Setting field values in a form

[BobRoyAce]

Let's say I have a form that has a particular table as its Record Source.
Let's further say that the table has 15 fields: Field1, Field2, Field3, ...,
Field15. Some of the fields have controls associated with them on the form
and some do not. My question is "How do I set the values of a Field in the
table that a form is associated with?" For example, in my example above, how
would I set the value of Field13, a field with no control on the form, to
12?

 

[Graham R Seach]

Bob,

It's usually good practice to add a control for each recordset field
returned by the table/query on which the form is based. Set their Visible
property to false. That way, you never have to concern yourself with saving
their value to the source.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia