Opdater form efter post oprettelse

se lige kode
Private Sub btnAssosiate_Click()
    Dim rstName As String
    rstName = Me.RecordSource
   
    'recordset and connection variables
    Dim Cnxn As ADODB.Connection
    Dim rstAssosiate As ADODB.Recordset
    Dim strCnxn As String
    Dim strSQL As String
   
    ' Open a connection
    Set Cnxn = New ADODB.Connection
    strCnxn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=p:\xxx\xxx.mdb"
    Cnxn.Open strCnxn
     
    ' Open Table with a cursor that allows updates
    Set rstAssosiate = New ADODB.Recordset
   
    strSQL = rstName '"Select orderID, autoID from tblOrder2Container"
    rstAssosiate.Open strSQL, strCnxn, adOpenDynamic, adLockOptimistic
   
   
        rstAssosiate.AddNew
        rstAssosiate!autoID = Me.OpenArgs
        rstAssosiate!orderID = Me.lstOrder.Value
        rstAssosiate.Update
        blnRecordAdded = True
   
    ' clean up
    rstAssosiate.Close
    Cnxn.Close
    Set rstAssosiate = Nothing
    Set Cnxn = Nothing

DoCmd.Close

End Sub

Der virker perfekt, men når jeg kommer tilbage til formen er de nyoprettede poster der ikke før jeg refresher eller requery??

Nogen der kan et trix

Jaze