Blank subform

[Sandi]

I just converted a Access 97 database to Access 2003 and I have a subform
that is just blank (none of the underlying fields display at all). I ran the
recordsource (query) and it has records and is correct but the subform
doesn't work (just the background color displays)? I have never run into
this before?

 

[Trey Davis]

Dear Sandi,

If you try to use "Blank" subforms, you will get an error. A subform has to
be bound to a table.

In the recordsource property of the form, put in your table name.

HTH

Trey Davis
Microsoft Access MVP

 

[Sandi]

Hi - I don't want a blank form and the form has a select query recordsource.
When I open the main form and click on a listbox, some fields are updated
with info and the subform (in mention) is supposed to be requeried
formname.requery but the form remains blank. Now if I make my selection and
open the subform from the database window on its own (with the main form
open) it is populated and looks fine but embedded it just has nothing.

 

[Sandi]

Sorry - I figured it out - there was some code on the open event that was
messing up that form.