I just moved my subform which performs the calculation up to the text
box area and replaced it with the subform. Now I either get the
calculation or a blank if no subform data, so that will be okay for
now anyway.
--- In AccessDevelopers@yahoogroups.com, "jmw95823" <[EMAIL PROTECTED]>
wrote:
> I have a field on my main form which shows the sum of $$ from
records
> on subform by common ID. If there are no records on subform, I want
> to show $0 in my main form text field instead of #Error or blank.
> Any help in reviving my memory will be appreciated. Thanks. Jim
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
