Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Set value of field to be same as last record?

Status
Not open for further replies.
djayam

djayam

Technical User
Aug 16, 2005
95
GB
Hi all (again)

I have my Orders subform (Record Source = Orders) within the Customers form. When I add a new order, I want the default Description field value to be the same as the Description field on the last record. Any ideas?

Thanks,

Jason
 
Sort by date Sort by votes
Hi
Maybe:
Code: 
Private Sub LastName_AfterUpdate()
Me.[i]Description[/i].DefaultValue = Chr(34) & Me.[i]Description[/i] & Chr(34)
End Sub
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question
Hyperlink Text of a field
Replies
1
Views
254
caykamanj1966
caykamanj1966
I
  • Locked
  • Question
How to get 2 codes to work together.
Replies
6
Views
624
hermanlaksko
hermanlaksko
MattGreer
  • Locked
  • Question
Add Field Description to a Form 2
Replies
5
Views
419
Andrzejek
Andrzejek
Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
2K
dhookom
dhookom
TechieJr
  • Locked
  • Question
Filtering for null or empty field
Replies
8
Views
1K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top