Missing Data

[Guest]

Hello,

I received an answer before on how to bind rows to a datasheet by using:

me.subformcontrolname.form.recordsource=strsql

I get the correct number of rows returned, but I don't have any data and
therefore, my datasheet on my subform is blank. My form and subform have the
default properties settings so I'm stuck here.

Any help would be appreciated.

Thanks,

Paul

 

[John Vinson]

Hello,

I received an answer before on how to bind rows to a datasheet by using:

me.subformcontrolname.form.recordsource=strsql

I get the correct number of rows returned, but I don't have any data and
therefore, my datasheet on my subform is blank. My form and subform have the
default properties settings so I'm stuck here.

Any help would be appreciated.

Well, I don't understand the problem then. You have no data. That's
what your form is showing you: no data.

You say "I get the correct number of rows" - if you copy and paste
strSQL into the SQL window of a new query, do you see the data that
you expect?

John W. Vinson[MVP]