right here we go.....
I have a procedure:
Private Sub DataValidation()
'This procedure is called to ensure all data is valid
'If not the user is prompted to amend the invalid data
'3 procedures are called to check the validity of the data held in the 3
'data input components on screen
NOW... within the first pro(titlevalidity( ) ) that is called I have a if statement where if a criteria is met then I want to display a prompt and stop the processing so say the 'title' hasnt been entered and I want to stop the validation and let the user makes the amendments.
To do this I am using Exit Sub. However this is only exiting the Titlevalidity( ), it then moves on to RateValidity( ).
I want to stop completely.
I'm assuming that I need to have a try..catch in the validity( ) that catches an exception and then parses it back to the try catch in datavalidation( ), is this right and if so how exactly do I do it im a bit unclear.
If not, what do u recommend?
Any1 save a man in need?