#Name in Forms

[Michael Wong]

I have a form which contains a textbox with the following Control Source:

="(" & Format(FProductsSub.Form.RecordsetClone.RecordCount,"#,##0") &
IIf(FProductsSub.Form.RecordsetClone.RecordCount<=1," item"," items") & "):"

It used to work until I reinstalled my PC from 0.

In the immediate window (as suggested by Allen Browne in
http://groups.google.com/group/micr...ess.formscoding&rnum=1&hl=en#18021b631eceaddb)

it works also, I just needed to add Forms.Products. (which is the main
form):

FProductsSub.Form.RecordsetClone.RecordCount

I checked the Refrences and DAO, ADO are there.

Have I missed something (References, Access's Options)?

 

[Michael Wong]

Never mind, I found out why:

Tools->Macro->Security->Low