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

  • Thread starter Thread starter dfeigen115
  • Start date Start date
D

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.
 
dfeigen115 said:
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.
Click to expand...


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
 
Thanks Marshal, I'll give it a try.
Dan

Marshall Barton said:
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
Click to expand...
 
Back
Top