Missing Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
Click to expand...

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]
 
Back
Top