End If Without block if error

Hi

I have theis pice of cade that looks for a match in a data table, deletes all of the matches from the table and the writes data that was entered into the form to the table.

I am getting a 'End If with out block if' error and I cant for the life of me work out where the problem is. If i remove the exit sub and end if the code complies and executes but the delete part of the code is skipped.

can anyone see where I am going wrong?

Many thanks

Please Login or Register  to view this content.

The 'End If' line you have highlighted has no corresponding 'If'.

Sorry but. Where would I put the corresponding if!

I don't know, you put it there! I'm with romperstomper. Take it out and see what happens.

Thats what I thought. But when I remove the the end if the program stops after

Please Login or Register  to view this content.

The code was working fine untill I added

Please Login or Register  to view this content.

I need this because I need to search the data table and remove any matches first.