upgrade from 2000 to 2003 problem???

[k0r54]

Hi,

In 2000 and xp i used this code to count the rows of a sub form : -

subform_controlname.form.recordset.recordcount

this no longer works in 2003 and i just get #Name? appearing instead???

Any idea's on why that is??

Thanks
Adam

 

[RuralGuy]

ac2003 may require the Me. at the beginning.

Or maybe you need a reference to DAO.

 

[k0r54]

Do you mean: -
=Me.Monthly_below_report_calls.Form.Recordset.RecordCount

That doesn't work

 

[RuralGuy]

Do you have a reference to DAO?

 

[k0r54]

erm.. im not sure how do i check??

 

[RuralGuy]

While viewing a code page (Alt F11) Tools>References MIcrosoft DAO 3.x Object Library should be checked. My guess is that ActiveX should *not* be checked. From the code page Debug>Compile. If there are no errors the try your code again.

 

[k0r54]

it wasn't checked and either was the debug but it still didn't work. I done a work around now though, by doing it inside the subform and then refrencin the txt box within there

 

[RuralGuy]

Glad to hear you got it working.