Sorry for the misspelling. As for the frmPartDetailSubfrm1, that is
the name of a subform that is on the main form. The subform has the
Part Description, Unit Cost, and a couple other columns of data
related to the specific part number. The subform is linked to the Main
Form via the Part Number. The Subform is populated when a part number
is entered in the main form.
Like I said in the original post this calculation has worked for a
number of years. Nothing has changed in the database. The only that
has changed is some of the users have been upgraded to Access 2003.
Users that have either Access 2000. or Access XP have no trouble at
all with this calculation function.
Thanks,
Del
"PC Datasheet" <nospam@nospam.spam> wrote in message news:<YBMWc.10933$2L3.1888@newsread3.news.atl.eart hlink.net>...[color=blue]
> In your extended cost calculation, Quantity is misspelled. Is
> frmPartDetailSubfrm1 the subform control on the main form and not the name
> of the subform? frmPartDetailSubfrm1should be referred to from the Forms
> collection like this:
> Forms!frmPartDetailSubfrm1
>
> --
> PC Datasheet
> Your Resource For Help With Access, Excel And Word Applications
>
resource@pcdatasheet.com
>
www.pcdatasheet.com
>
>
> "Del" <dtlabo@yahoo.com> wrote in message
> news:c2f38125.0408241030.b9b9229@posting.google.co m...[color=green]
> > Thanks in advance for any help.
> >
> > I have a database that was created in Access 2000. Several users have
> > been upgraded to Access 2003. Since upgrading to 2003 we have noticed
> > that some of the calculated fields are not being populated. The
> > database is a samll invoicing database on the form and report we have
> > columns call Unit Cost. This is the actual cost of the part and is
> > pulled from our parts master table and is displayed in a sub form and
> > subreport, linked to the master form and report by Part Number. On the
> > form and report we have a column call Quantity which is the number of
> > the parts ordered by the customer. We then have a calculated column
> > called Extended Cost. The Extended Cost has the following
> > calculation...
> >
> > =([Quantitly1] * [frmPartDetailSubfrm1]![Unit Cost])
> >
> > This calculation has worked fine from the time the database was
> > created several years ago, until now. When the database is run on a
> > machine with Access 2003 this calculation doesn't work. However the
> > machines that have Access 2000, or XP the calculation works fine.
> >
> > Any ideas????
> >
> > Thanks again.
> > Del[/color][/color]
