Microsoft Access 2007 RecordsetClone doesn't work

[samhck2]

I am using this code : [Form].[RecordsetClone].[RecordCount]
But, version 2007 has this error : #Name?
can someone help???

Millions thanks.

regards, sam

 

[Douglas J. Steele]

That's not valid syntax in any version of Access.

You need either

Forms!NameOfForm.RecordsetClone.RecordCount

or

Me.RecordsetClone.RecordCount

 

[Paul Shapiro]

[Form].[RecordsetClone].[RecordCount] used to work as part of a control's
control source, but if you check Allen Browne's list of new bugs in Access
2007, it doesn't work in A2007. Me.RecordsetClone.RecordCount still works in
VBA, so his suggestion is to use a function as the control's control source
and put the calculation in the function.

That's not valid syntax in any version of Access.

You need either

Forms!NameOfForm.RecordsetClone.RecordCount

or

Me.RecordsetClone.RecordCount

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I am using this code : [Form].[RecordsetClone].[RecordCount]
But, version 2007 has this error : #Name?
can someone help???

 

[samhck2]

That's not valid syntax in any version of Access.

You need either

Forms!NameOfForm.RecordsetClone.RecordCount

or

Me.RecordsetClone.RecordCount

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)

I am using this code : [Form].[RecordsetClone].[RecordCount]
But, version 2007 has this error : #Name?
can someone help???

Millions thanks.

regards, sam- Hide quoted text -

- Show quoted text -

Thanks Doug Steele.

 

[samhck2]

[Form].[RecordsetClone].[RecordCount] used to work as part of a control's
control source, but if you check Allen Browne's list of new bugs in Access
2007, it doesn't work in A2007. Me.RecordsetClone.RecordCount still works in
VBA, so his suggestion is to use a function as the control's control source
and put the calculation in the function.

That's not valid syntax in any version of Access.

You need either

I am using this code : [Form].[RecordsetClone].[RecordCount]
But, version 2007 has this error : #Name?
can someone help???- Hide quoted text -

- Show quoted text -

Thanks Paul. I write the code in VBA, it works.