How to carry forward Combo Selection to new record in form?

[Ariful Islam]

I want to carry forward Combo Selection to new record in form, I used various method, but problem is when i select from Combo after update event doesn't work. Can anybody please solve it?

 

[Gasman]

Here is how I managed it in an early DB of mine

Private Sub Date_ID_AfterUpdate()
    If Me.chkCopy Then
        Me![Date_ID].DefaultValue = """" & Me![Date_ID].Value & """"
    End If
End Sub

Me.chkCopy is a checkbox I use to indicate I want to copy this and other combo values for the new record.

HTH

 

[arnelgp]

Same as Gasman but on before uodate and current event if the form

 

[Ariful Islam]

Little more problem, when i click on ''New (blank) record'' department name keep carry forward but "PassMark" does not change with respect to "Department". Why?