frm.FilterByOn=True closes application

  • Thread starter Thread starter Matt Gauch
  • Start date Start date
M

Matt Gauch

I've added some toggle buttons (Triple state) to a continuous form to sort
the data on the form by that column. When the code behind the buttons
executes frm.FilterByOn=True, Access closes the application without any
warning. The code is actually in a code module, not directly behind the
button, and I'm calling the routine from toggle buttons on other forms with
no problem. The MDB has been compacted/repaired several times to no effect.
Any ideas would be greatly appreciated.

TIA,

Matthew D. Gauch
President/Principal Consultant
Humanized Systems Consulting, Ltd.
(e-mail address removed)
 
Just guessing, but the form may be corrupted. Create a new form and copy the
controls onto it. See if that helps.
 
Are you saying that a msgbox placed >immediately before< the FilterOn=True
is displayed, but one placed >immediately after< that statement is not?

TC
 
try to do a decompile of your code (MSACCESS.EXE YOURmdb.mdb /Decompile
Make sure to back it up first
after the decompile , enter the vba editor and recompile your project again.

This should do the trick
 
Back
Top