469,283 Members | 2,297 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,283 developers. It's quick & easy.

SubForm in Datasheet View

Hi,

I have a main form "frmBldgFloor" and SubForm within the main form
"fsubBldgFloor".
In the SubForm the values in the text fields are being populated from a
recordsource.
I have these values being populated in Form Detail Section.
Also I have Form Footer where I have text boxes showing Sum of those
recordsource values.

When I set the Default View of subform to Continuous it shows the Sum
of recordsource values but when I change the Default view to Datasheet
it doesnot show the Sum of recordsources in the textboxes which are
there in the design time.

Please can anyone suggest how to solve this problem of subforms.
Thanks, any suggestions are welcome,
Shalini

Jun 7 '06 #1
1 2755
A datasheet view is not just a different looking kind of continuous form.
You can't display lots of things on a datasheet. For good or ill, it looks
exactly and to some degree acts like a spresheet. You can size columns, you
can size rows, you can re-order the columns. You can't display a footer.

You'll have to live with continous form in your subform or do without the
sum() in the footer.

That said, there are other ways to get stuff like that. If you can
construct the SQL you use for the subform and make it available in code, you
can put a textbox back up on the main form and possibly write a DLookup
statement on the fly to populate the textbox with sum from the same records
you're displaying in your subform.
Jun 8 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by MacDermott | last post: by
4 posts views Thread by wayne dooley | last post: by
1 post views Thread by Matthew Wells | last post: by
2 posts views Thread by Smartin | last post: by
7 posts views Thread by Ken Mylar | last post: by
1 post views Thread by runner7 | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.