By the way, I know the [] shouldn't be needed around the field name unless there are spaces, but the results are the same with or without.

Follow these steps to see if they help:

First copy your code and paste into Notepad for safe keeping.
Delete the button.
Compact your database.
Add a new button.
Paste in your code.

Let us know if this fixes the problem.

Kevin,
The error message is unchanged.

bob

Hi Bob
I recreated the table and form and used your code. It worked as it should.  John

Is it just this button causing problems? Does it work on other forms?
Perhaps create a new form, for testing purposes, to see if the button works there.
Or create a new database and import all object from this database to the new one.

Definitely nothing wrong with the code. I have used similar code in past projects with no problems.

I suggest going through Richard's Troubleshooter

Thanks for the suggestions. It appears that I may have a form issue and an Office or Windows problem. When I create a button in a different form or a different database, I don't get an error message but it does not do anything. Same with a duplicate record button. I'll try it on some different computers and see what happens. Hopefully and Office reinstall and new form will fix it.