Subform won't show data (Access '97)

  • Thread starter Nick via AccessMonster.com
  • Start date
N

Nick via AccessMonster.com

Hello,

I am using a form for manual data input that has a subform named
"subDatasheet". subDatasheet is bound to a datasheet form that contains a
few records.

Up until about an hour ago, when the manual data input form opened,
subDatasheet displayed all the records on the datasheet form. However, now
subDatasheet will not show records, but it is still properly linked (i.e. I
can still enter data into subDatasheet and it transfers correctly to the
datasheet form and corresponding table)

Is there a property that can be set to force existing records to be shown?
Am I dealing with a glitch or my own mistake? (From experience, it's
probably my own mistake, but oh well)

Thanks for any help,

Nick
 
N

Nick via AccessMonster.com

Somewhat solved the problem, just for anyone else with the same issue:

I just dragged and dropped the datasheet form onto my manual input form, it
created another subform, and I compared the two subform properties.
Everything was exactly the same, but the dragged and dropped subform worked,
while the original subform did not (the original was drag and drop as well).
If anyone has the same problem and knows why it happened, I'd be interested
to hear.

Nick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top