help w form field?

[jedder18]

=([frmservices_2013].[Form]![sub2013])

I have this expression in a field on a form.
It's been a really long time since I worked in Access.
is sub2013 a field on a form, in a table?

It's doing a running total of a field from a form
I can't find a subform with this name, or a field anywhere, :banghead:

I'm drawing a blank.

using Access 2007

need my memory rebooted

 

[jedder18]

Well never mind....
I just found it as a hidden field on another form...

DUH!

 

[AlexN]

=([frmservices_2013].[Form]![sub2013])

I have this expression in a field on a form.
It's been a really long time since I worked in Access.
is sub2013 a field on a form, in a table?

It's doing a running total of a field from a form
I can't find a subform with this name, or a field anywhere, :banghead:

I'm drawing a blank.

using Access 2007

need my memory rebooted

It seems [sub2013] is a control in subform "frmservices_2013".

 

[spikepl]

This expression will work for a field Sub2013 held in a subform which currently is in the subform container called frmservices_2013 which is on the current form.

BTW: a year buried in object or control names implies most often a structural problem, because data does not belong in object or field names.

 

[jedder18]

I found it as a total field in the form.
I am copying all the forms and subforms and changed the name to frmmthly for all the new ones.

Thanks for the help.