Database VBA Autofilter Issue

Afternoon folks,

I'm working on a database just now, well when I say working I mean I've copied one and changing to what what I need. It's one from the good old RoyUK (who has been really helpful in the past)

Started off Ok, and still a lot to do. But found a wee problem which I cannot work out how to fix. Everthing works fine, but when I start the application, and change information and press the ammend button, I'm getting an error, and cannot see anything wrong ?

I've attached example.

Hi,

I tried the code on my computer and it stopped at the command:

Please Login or Register  to view this content.

This is probably because all the data is already shown. I tried using the filter (so only the data for "Holmes" was visible), repeated the Amend function and that worked fine.
The ShowAllData comand isn't absolutely essential so you could bypass it just by commenting it out by putting an apostrophe, " ' ", at the start of that line. The code will turn green signifying that it is to be ignored.

Should work fine then and you can still play around with some coding if you particularly want the ShowAllData functionality.

Post back if you need any more help,

Tris

Cheers Tris, that did it.