Hello, I’m sure this must be a common problem but I can’t seem to find a simple solution…
I created a Form to display the record details of a Query. I have four command buttons (First Record, Next Record, Prev Record, Last Record) to scroll through the records. The problem is when the EOF is reached and the user clicks the Next Record button a blank record appears and if they click the Next Record button a second time the program goes into Debug. And so my questions are…
1. How can I detect the EOF condition?
2. How can I disable (or hide) the Next Record command button so it won’t go into Debug if it is clicked again?
Thank you for your time.
I created a Form to display the record details of a Query. I have four command buttons (First Record, Next Record, Prev Record, Last Record) to scroll through the records. The problem is when the EOF is reached and the user clicks the Next Record button a blank record appears and if they click the Next Record button a second time the program goes into Debug. And so my questions are…
1. How can I detect the EOF condition?
2. How can I disable (or hide) the Next Record command button so it won’t go into Debug if it is clicked again?
Thank you for your time.