Filtering a combo box

[RenaG]

I have been researching the Undo in VBA and am beginning to wonder if the problem lies in the fact that this field is on a subform. I haven't found a solution but have seen some posts where others are having a problem with the undo working in a subform. Unlinking the subform from the main form seemed to help in one situation but that is not an option here.

~RLG

 

[RenaG]

I did the compact and repair - no change. I did the decompile, compile, compact and repair the database and it still doesn't work. The document I found on this forum said that once the app is decompiled, it should be significantly smaller. Mine was insignificantly larger.

~RLG

 

[RenaG]

I just tried setting up another subform in my db to do the same thing and got the same error. If it is caused by corruption on the other subform, I wouldn't think this subform would have the same issues.

~RLG

 

[RenaG]

FINALLY!!!! Got it to work. I took off the reference to the combobox name in the undo.

From:

        Me.tdescription.Undo

To:

        Me.Undo

And it works like a charm!

Thanks for all your help!

~RLG