I have a table "BidDetails" in an Access 2010 Web db the record source bound to a form "BidDetails" the fiefds are
ID = AutoNumber
BidId = Number
Area = text
ItemID = Number
Everytime I add a new record I want the new record field "Area" default value to be the value in the previous record "Area" field.
Thanks
RoofBid