Fields from which calculations are derived are currency with default
of 0. If no records correspond to main form ID, then there is
nothing on subform to calculate on main form.
--- In AccessDevelopers@yahoogroups.com, "Jones, Glenn P MSG (Ret)
FL-ARNG" <[EMAIL PROTECTED]> wrote:
> Hi Jim,
> Do you have all the fields on your subform as numeric fields and
have set
> the default to 0?
>
> Glenn P. Jones
> IHS
>
>
>
> -----Original Message-----
> From: AccessDevelopers@yahoogroups.com
> [mailto:[EMAIL PROTECTED] On Behalf Of jmw95823
> Sent: Tuesday, 12 July, 2005 5:13 PM
> To: AccessDevelopers@yahoogroups.com
> Subject: [AccessDevelopers] This is easy, but I forgot how to do
it: Show
> main form calculation as $0
>
>
> 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
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/
