How to search through each record
- Thread starter retkehing
- Start date
vis781
Well-known member
A check? A check for what?
For example, i need to perform a validation search to prevent the user from keying two same primary keys. I have no intention of using the try...catch because its error message is quite profound to the novice user. To make it simple, i will go for another method. That is the question i am asking.
One more question, I have used select...where SQL statement to find the proper record but how to pass the data and display them in each textbox. Thank you.
One more question, I have used select...where SQL statement to find the proper record but how to pass the data and display them in each textbox. Thank you.
vis781
Well-known member
Firstly, if the input focus is a textbox, you can use it's On validating event, use a for each loop to iterate through the datarow collection and check the value of the input against each row.
For your second bit check out the dataform wizard. It'll start you off in the right direction.
For your second bit check out the dataform wizard. It'll start you off in the right direction.
Similar threads
