Data sheet view

[Guest]

I have a form that when displayed in form view displays
the Main form and 5 sub forms perfectly.

Recently I went into the same form in Datasheet view (my
bosses prefered viewing method)and the information is no
longer in a table type view. Instead each record displays
one of the sub forms.

Can any one help.

 

[Rob]

I believe that when in Datasheet mode the form will
display as a table, and only display associated records
who have links in the Relationship form. If possible, set
up the relationships (if you don't have them set up
already) and see if that works.

You may be using the subform to establish the link, and
since datasheet shows like a table, you'd need to
associate records via hard-set relationships instead of
the on-demand relationships you can use when setting up
subforms.

If you already did that, then I have no idea (let me know
when you find out, hehe).