Default Values = Previous entry

olorin

Registered User.
Local time
Today, 15:04
Joined
Jun 9, 2006
Messages
81
I have a form that I fill in the shipping details of goods out.
Sometimes we ship out a few different items with the same company on the same day on the same vehicle etc etc.
I would like to know how to set the fields in the new record to be the same as the previous entry and save a lot of re-entering of the same data, and thereby only having to change the item shipped.
Is this possible with code?
 
I can't even count how many times and different ways this issue has been addressed on this forum. Did you try a search?
Here's a good one.
 
Ditto Sergent.....

Making the next field in records default to the last record. (UserID as an example)

In the After Update event of the UserID field put code like this:
Me![UserID].Tag = Me![UserID].Value
In the On Enter Event of the same field put code like this:
If Not Me.NewRecord Then Exit Sub
If Not (IsNull(Me![UserID].Tag) Or Me![UserID].Tag = "") Then
Me![UserID].Value = Me![UserId].Tag
End If

The UserID will not carry over into your next session with the form but will work as long as the form is open....

You will need to customize and add this code to each control you wish to default to
 
Thank you both for replying.
I am a "dumbo", I should have posted that I have found the solution by searching through this forum.
I get too impatient sometimes.
I am sure I will need the services of this great knowledge source again in the not too distant future.
Thanx again for replying
p.s.
Luv your signature messages :)
 

Users who are viewing this thread

Back
Top Bottom