The way my application is written is that I press an enter data button that uses (Adodc1.Recordset.AddNew) which clears my fields and adds a record, then I'm allowed to enter data. To verify that the data has in fact been entered i use the navigation buttons to cycle thru the recordset. However, i get a runtime error when the date is input properly.
For example: format = dd/mm/yy, example: 26/08/02 v.s. an improper input date data such as 31/31/02 which triggers the error.
How can i catch this given that the record has been already added before the data is actually input?
Ive tried setting an error handler on the navigation buttons but it doesnt work correctly, what kind of code would i need to validate the date for this text box?
I was confused when you said "However, i get a runtime error when the date is input properly". Anyway, when you post, including the error message and being as descriptive as possible (like the masked edit control) is helpful. You can also include your code in a lostfocus event for the date field so that the user will have to choose a correct date. You can also validate as the user is entering the date to prevent user input error as well - this is a little more code intensive than just running isdate.