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

Afrosheen via AccessMonster.com wrote:
Good morning,
I have 3 fields [printtab], [rotation], & [adn]. Rotation and adn are
True/False fields. The printtab is a number field.

In stead of having 3 SQL statements, I'd like to update the fields like this:

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

'************* Updates the Config File *************
CurrentDb.Execute strSQL, dbFailOnError

When I tried it it kept on giving me errors.
Error:3061. Too few parameters. Expected 1.

Can it be done like above or do I need to use 3 SQL statements?

Thank you for your input.