Thanks for the quick come back. Your suggestion worked. I really appreciate
the help
There was a field error spelling problem. I should have used [printab]
instead of [printtab]
Thanks again for the direction.

John Spencer wrote:
No, it can be done in one query. The error message indicates that one of the
field names is incorrectly spelled or that True is being misunderstood for
some reason.

Try
strSQL = "UPDATE tblconfig SET [rotation] = -1, [printtab] = 1, [adn] = -1"

If that still gives you the same error, double check the spelling of the field
names.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Good morning,
I have 3 fields [printtab], [rotation], & [adn]. Rotation and adn are
[quoted text clipped - 14 lines]

Thank you for your input.

--
Message posted via http://www.accessmonster.com