Continuous form, carr over value

[Mtyetti2]

I've seen several posts similar to this problem, but still can't find a solution. I have a continuous form set up to enter 'legs' for a vehicle database. Each record represents a portion of the drive. After entering the first leg, when I tab to the next record, is there an easy way to carry over the information from the previous record? ie: Driver, vehicle information.



Not sure if I have to set a default value, or DLookup, or combination of both??? Any help is greatly appreciated.
Thanks!

Scott

[June7]

Requires VBA code to set the DefaultValue property. The code can go in the control's BeforeUpdate event procedure. Like:

Me.Controlname.DefaultValue = "'" Me.Controlname & "'"

[Missinglinq]

You can use the AfterUpdate event of the Control holding your data to set the DefaultValue for the Field. From that time forward, until you either manually change the data or close your form, the data will be entered automatically in each New Record.

Private Sub YourControlName_AfterUpdate()
   Me.YourControlName.DefaultValue = """" & Me.YourControlName.Value & """"
End Sub

This syntax is valid for Text, Number, DateTime and Boolean Datatypes.

You’ll need to do this for each Control that you want to ‘carry forward.’

Linq ;0)>

[Mtyetti2]

Missinginq,

This is very close to what I am looking for. However, this code forces to the data to remain as the default value even when I close the form and reopen it. When I reopen the form, I would like all the fields to be blank, and then fetch the default values when I enter data on the new record. Hopefully this makes sense.

[June7]

The form opens to existing records and displays data from the table, not the DefaultValue property.

If you want the form to open only to New Record, can set the form DataEntry property to Yes.

Or use the Access navigation bar to move to New Record.

Or use code to move to New Record.