Solved: help with VBA

[oxicottin]

Hello, I have a form that works perfectly except im trying to run a button to sort a continious form and on the form I have rows enabled and some disabled with conditional formatting on my 5 text/combo boxes excluding chkStatus box. Well when I open the form all the correct rows are disabled and enabled but when I click the button to sort by employee name it sorts the employees names but it now disables the first or last row? Im new to VBA so can someone explain what im doing wrong... Thanks!

[orange]

oxicottin

I don't understand the problem as you describe it. I looked at your database. The sort a-z and sort z-a seem to work fine.

The rows/records that are disabled are the ones with Active/inactive checked. There is no change in the enabled/disabled rows that I can see.

Perhaps you could expand on what you expected to occur under what circumstances.


jack

[oxicottin]

For some reason it wasnt working but now it is? Weird!

Thanks,
Chad

[X-BRichard-X]

Stay off the oxycotin...

[thomaspatton]

Stay off the oxycotin...
QFT