Repeat previous data

[Ricoy-Chicago]

To create a weekly report I use:
"items" - this value changes every week
"Cost of item" - this value changes 2-3 times a year
"week No" - needed to create the weekly report based on "items" and "Cost
of item"

The user needs to enter the "week No" and "Cost of item" ("items" is counted
by Access). How can i set the front-end data entry screen so the "cost per
item" from the previous week is copied automatically to the new record for
the new "week No"?

 

[Steve Schapel]

Ricoy,

Are the "Week No" sequential numbers? If so, make a query based on the
table that this data goes into, and sort Descending on the Week No
field. Then, set the Default Value property of the Cost Of Item control
on your form to the equivalent of...
DLookup("[Cost of Item]","NameOfQuery")