VBA Code problem

[WinterCoast]

I am at my wits end as to why my code listed below isn't working. The only field that will update when I click my Save button is txtVenue. Every other field resets to the prior value when this code runs. Any ideas? I have a headache from trying to figure this one out.

Thanks in advance,
Scott

Please Login or Register  to view this content.

[WinterCoast]

Can anyone help me on this? I've been trying to figure this out for 2 weeks and have no idea. I have another sheet similar to this one and it works fine and the code matches up.

I've looked at each line of code, and I cannot find any problems. But the line (iVenue(i).Value = txtVenue.Value) is the only one in the IF statement nested inside the FOR...NEXT loop that works.

Any ideas will be GREATLY appreciated. I'm using Excel 2003.

Scott

[mudraker]

Can you post a copy of your workbook - The one you are having the problem with