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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201006/1