Replies

Hi Andrew,
Here

No, this is a command bar we

Sorry, let me rephrase my problem a little. For some using the system, the errors don

That

Sorry the reason I can

Yes that was more along the lines of what I was looking for, thanks.

Thanks Dave but I was looking more along the lines of filtering an existing list further rather than having to create it over anew.

Never mind I fixed the problem, I was setting a combo boxes list index property before adding items to the control, so ofcourse it would error out. I changed the order & it

Thanks for the idea but I got around my problem another way that seems to be working after 3 weeks of struggling. I just hit upon it so I

No, the IF statement was not failing it was the NEXT statement, it could not go onto a control that was disabled on the toolbar. For the past 2 weeks I

Yes I did add an error handler, it helps resume after a type mismatch error that was occurring in the function.

errorHandler:
    Select Case err.number
        Case 13
            Resume Next
    End Select

Charlotte, the first IF condition you supplied is giving me an INVALID PROCEDURE CALL OR ARGUMENT even though I have a value in one of the combo boxes.

Hi Charlotte, thanks for the response! I

Well basically my menu bar has grouping based on the logon user

Thanks, my On Error GoTo errorHandler wasn