Access 2003 Error 2166 unsaved changes trying to set locked in unbound form and control

Tom,
I have a combobox (ComboGroup) whose OnChange calls a function (SetParametersEnabled) where in you find this code ... (The error only occurs when llTrueOrFalse is 'True')

With [Forms]![Export To Excel Preselection Screen]

            !txtBeginYearFrom = ""
            !txtBeginYearTo = ""
            !txtFiscalYearFrom = ""
            !txtFiscalYearTo = ""
            !txtFYEndDateFrom = ""
            !txtFYEndDateTo = ""
            !txtFYmFrom = ""
            !txtFYmTo = ""
            !txtFYFrom = ""
            !txtFYTo = ""

        !txtBeginYearFrom.Enabled = llTrueOrFalse
        !txtBeginYearFrom.Locked = llTrueOrFalse <- when llTrueOrFalse is True the error occurs here
        !txtBeginYearTo.Enabled = llTrueOrFalse
        '!txtBeginYearTo.Locked = llTrueOrFalse <-Same here
        !txtFiscalYearFrom.Enabled = llTrueOrFalse
        '!txtFiscalYearFrom.Locked = llTrueOrFalse <-Same here
        !txtFiscalYearTo.Enabled = llTrueOrFalse
        '!txtFiscalYearTo.Locked = llTrueOrFalse <-Same here
        !txtFYEndDateFrom.Enabled = llTrueOrFalse
        '!txtFYEndDateFrom.Locked = llTrueOrFalse <-Same here
        !txtFYEndDateTo.Enabled = llTrueOrFalse
        '!txtFYEndDateTo.Locked = llTrueOrFalse <- ...
        !txtFYmFrom.Enabled = llTrueOrFalse
        '!txtFYmFrom.Locked = llTrueOrFalse
        !txtFYmTo.Enabled = llTrueOrFalse
        '!txtFYmTo.Locked = llTrueOrFalse
        !txtFYFrom.Enabled = llTrueOrFalse
        '!txtFYFrom.Locked = llTrueOrFalse
        !txtFYTo.Enabled = llTrueOrFalse
        '!txtFYTo.Locked = llTrueOrFalse

end with

But regardless of from where the code is run it always fails the same. I believe the problem exists due to the form being unbound hence the Dirty is negated.

If I can remember correctly, you cannot disable or lock  a control when it has the focus. Is this the case?

Good try but I was passed that one in the beginning. The correct answer is; An unbound form (a form with no recordset) for some reason can not handle the (dot) .Dirty and hence can not be marked as saved, or something like that. Anyway my work around was to use a dummy table (one with only 1 record) as the source for the form.

Then I added

...

Me.Recordset.MoveLast

Me.Recordset.MoveFirst

before the other lines of code above and presto it all worked.

Hope that helps someone out there in AccessLand.

Bill In Ottawa

I know this is an old thread, but I was looking for the same thing and your answer gave me an idea.

I am also using an unbound form and trying to lock a textbox after giving it a value (and unlocking it if there's no value to give it).  I just used:

Me.Dirty = False

before locking the textbox.  Works like a charm!  Thanks for showing my the way.