It seems like Recordset.RecordCount is buggy in a couple of places in my program. Here's one: I have a form that is opened sometimes with a filter (passed as a parameter in openform) and sometimes not. Basically, when the form launches it will be bound to either one row of a table or all of rows. I want to adjust the Navigate buttons to be gone if there's just one record. So in my Form_Load procedure I put this.
If Form.Recordset.RecordCount > 1 Then Form.NavigationButtons = True Else Form.NavigationButtons = False End If Even when unfiltered and there are multiple records in the main table bound to the form it will not show the NavigationButtons UNLESS I put a debugger BREAKPOINT on the IF statement and resume execution as is. With the BREAKPOINT it works as expected. Without it, it doesn't. And it seems that it's the RecordCount screwing things up. I have another piece of code where RecordCount doesn't work properly. Am I missing something here?
