Hi
I have:
1 main form called frmMain
1 subform called frmScore
1 unbound text box called txtcountScore in footer of subform txtcountscore =count(*) to count records entered in subform
1 unbound text box on frmMain called txtchkTotal
I want to reference this count in the main form so that when command button is clicked at later stage, an error message would appear if the count does not match another field called Total Received
I want to pass the total number of records in my subform into txtchkTotal on my frmMain
Ive tried many different variations as control of txtchkTotal to lookup the Count on my subform
=[frmScore]![txtCountScore]
=[me]![frmScore].[Form]![txtcountscore]
but no matter what variation of syntax i use, I get #Name. in my text box on frmMain
Is this because the field i am looking up is unbound/calc field or is it incorrect syntax?
is there a better way of doing this?
thanks
I have:
1 main form called frmMain
1 subform called frmScore
1 unbound text box called txtcountScore in footer of subform txtcountscore =count(*) to count records entered in subform
1 unbound text box on frmMain called txtchkTotal
I want to reference this count in the main form so that when command button is clicked at later stage, an error message would appear if the count does not match another field called Total Received
I want to pass the total number of records in my subform into txtchkTotal on my frmMain
Ive tried many different variations as control of txtchkTotal to lookup the Count on my subform
=[frmScore]![txtCountScore]
=[me]![frmScore].[Form]![txtcountscore]
but no matter what variation of syntax i use, I get #Name. in my text box on frmMain
Is this because the field i am looking up is unbound/calc field or is it incorrect syntax?
is there a better way of doing this?
thanks