The related question explains the issue that I am having. I wasn't able to reproduce the error for some reason, but have now been able to reproduce it 100% again.
I'm getting a "Either BoF or EoF is true..." error when I'm neither at the beginning or end of my file.
My problem is isolating where exactly the issue is starting. I know that the issue is happening when I try and MovePrevious at a specific point in my code. For some reason why I try at this point, it doesn't like it and thinks I'm at the EoF or BoF.
I've used the MovePrevious command in other portions of my code without issue.
I placed this bit of code prior to the MovePrevious which is giving me an error and oddly enough it says that "Neither BOF or EOF is True". The next line is my MovePrevious which crashes and returns the error "Either BoF or EoF is true..."
Any thoughts on how I can possibly debug this more and figure out what the heck is going on?
If adoInputRS.BOF = True Then
MsgBox "BOF is True"
ElseIf adoInputRS.EOF = True Then
MsgBox "EOF is True"
MsgBox "Neither EOF or BOF is True"