Handling Report Fields in VB 1

[jt643]

I want to take the field from a Report Footer that stores the numbered results of a calculation on the report and transfer that value to a field on a table in my database.

I am attempting the following:

PreviousRst.Edit
PreviousRst!PreviousDraw = Me.TotalChecks.Value
PreviousRst.Update
PreviousRst.Close

Where Me.TotalChecks is the field on the report with the number I want to take to my 'Previous' table.

When I started coding this, the 'auto code' option was there for 'Value', but now for some reason 'Value' is not available.

Help!

 

[Remou]

You can just say:
Me.TotalChecks

But I hope you are happy with what you are doing, it seems to be breaking so many rules ...

 

[jt643]

Thanks Remou.

I'll give that a try.

Rules of Access or company rules???

I'm kosher on the latter.

 

[Remou]

Rules of Access, I will try and dig up some quotes, if you like.

Glad to hear that you are not sneaking company totals :-D