Form Field Default Setting

[roofbid]

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

[weekend00]

in form_current event:
Private Sub Form_Current()
If Me.newcord Then
area = DLookup("area", "BidDetails", "id=" & DMax("id", "bidDetails"))
End If
End Sub

[roofbid]

in form_current event:
Private Sub Form_Current()
If Me.newcord Then
area = DLookup("area", "BidDetails", "id=" & DMax("id", "bidDetails"))
End If
End Sub

Thanks for the reply. Will that work in Access 2010 web db?

[weekend00]

Not sure, I've never touched Access 2010