setting table field to calculated value on form-object required er

[dfeigen115]

On a form, I have several total value fields with a data source defined by
formulas (a running total of the various values entered in the form). As the
form is populated the running total fields are updating as expected.

When the user click the submit button, some additional edits are performed
after which I want to assign the calculated total to a field in the database
table. I'm currently using a statment formatted as

databasetable.fieldname = me.calculatedfieldname

I've verified the table & field names as correct, but I keep getting an
"object required" error when the code reaches the first of these statements.

Any suggestions will be appreviated, thanks in advance for you assistance.

 

[Marshall Barton]

On a form, I have several total value fields with a data source defined by
formulas (a running total of the various values entered in the form). As the
form is populated the running total fields are updating as expected.

When the user click the submit button, some additional edits are performed
after which I want to assign the calculated total to a field in the database
table. I'm currently using a statment formatted as

databasetable.fieldname = me.calculatedfieldname

I've verified the table & field names as correct, but I keep getting an
"object required" error when the code reaches the first of these statements.

To do that, you would have to go through the table object.
A form does not automatically make table objects accessible.
If the form is bound to that table and if that field is
included in the form's record source, then its fields are
included in the form's properties. So you could use:
Me.fieldname = Me.calculatedtextboxname

 

[dfeigen115]

Thanks Marshal, I'll give it a try.
Dan

To do that, you would have to go through the table object.
A form does not automatically make table objects accessible.
If the form is bound to that table and if that field is
included in the form's record source, then its fields are
included in the form's properties. So you could use:
Me.fieldname = Me.calculatedtextboxname