Form controlsource load

[IpeXeuS]

Hello there,

I've this weird thing again and it's about adding a new record. Ok, I just added this feature that form loads controls sources dynamically on load event. Controlsource fields doesn't contain anything now cause I moved those source datas to controls tag property field.

Here's a onload event code:

    Dim CTRL As Control
        
    For Each CTRL In Me.Controls
        Select Case CTRL.Properties("ControlType")
            Case acTextBox, acComboBox, acListBox
                CTRL.ControlSource = CTRL.Tag
            Case Else
        End Select
    Next CTRL
        
    Set CTRL = Nothing

Now I can't add new records to form, cause line for inserting new record is missing, if you know what I mean.

If you guys can help me with this, I would be grateful and all replies would be approciated very much.

 

[Rich]

Where are you expecting to add records if you have no record source?

 

[IpeXeuS]

Like I said before, I load each control source on form's load event. But hey, now I can see new record line, but it's locked or disabled somehow and I don't know how?