I’ve been plagued with this intermittent problem that is now happening pretty consistently. I have a main form that has a search button on it. When the end user selects the search feature and the criteria returns multiple records I launch another form (vbModal) displaying the return in a ListView grid. I have a select button, a cancel button, and code in the double click event. In the double click and select button events it takes the index number of the record, loads it into a global variable to pass the value back to the calling form, then closes the form using the command Unload Me. Clicking on the Cancel button simply executes the Unload Me.
The error I’m getting is “Invalid procedure call or argument” and it occurs when I attempt to select the record. It is a generic error not handled by any error handler in the form or calling form. This is unusual to me because I went through every line of code and made sure everything was trapped by an error handler (also verified that I’m releasing all my object variables while I was at it).
Extremely frustrating that it works fine in my development environment but will error every time for every record when running on the server. This is in a citrix session but that shouldn’t make a difference. The server was recently built and has all the updates on it with the latest MDAC. I had to use a series of message boxes to identify exactly where the point of failure was and keep compiling the code to the server. I found it was occuring in the Unload Me statement itself. I’ve tried Unload frmDupes (the name of the form), I’ve tried hiding the form…no matter what I try I still get this error and I can’t even figure out where it is being spawned from.
I am completely out of ideas and would appreciate any suggestions.