Add a value to the underlying table field of a form using field on

[aquabp]

In The form? What event would that go to? On Activate? How would I get it to load to the field? is it just me.MSort= that variable or rs! The variable is from the form event?

So I set rs to a variable and put this code in a form event?
Then in the MSort field I call the variable and format it there?

Is this the idea?

[ItsMe]

What event would that go to?

I do not know, maybe OnCurrent. Maybe more than one event. Maybe also and AfterUpdate of a control.

[aquabp]

I am still trying to get the select statement to work in one of the form events. I read another post on this forum that I think will straighten me out, but until then I will use this code. Once I switched: RD = Screen.ActiveForm.RDate to this line: RD = Me.RDate.Value

Private Sub MSort_Enter()


Dim RD As String
Dim MS As Long
    
    If (Me.MSort) = 0 Then
    
        'finds the RDate for the MSORT field
        RD = Me.RDate.Value
        MS = Format(RD, "yymm")
    
        'Places the above NRec into the GSort Control
        Me.MSort = MS
        DoCmd.GoToControl "VSort"
    Else
        Me.VSort.SetFocus


End If


End Sub

Thanks Itsme for all your help and time! It is greatly appreciated!!
aquabp