select/deselect all records in form

[Lhuffst]

Monthly we import customer address information and need to print labels. The import is done when the database is opened (autoexec). From there the user brings up a form that displays the data as well as a checkbox. The checkbox is so the user can choose which records they want labels created for. Typically there isn't very many records but occasionally there are more than 50. I would like to create a command button that will automatically select/deselect the checkbox so the user doesn't have to do it one at a time. Does anyone have any samples how this could be accomplished?

 

[PHV]

In the Click event procedure of the button:

Docmd.RunSQL "UPDATE [i]yourTable[/i] SET [[i]your YesNo field[/i]] = (Not [[i]your YesNo field[/i]])"
Me.Refresh

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SeeThru]

You could also use a recordsetclone of the form if the data source is more complex than a simple table.

SeeThru
Synergy Connections Ltd - Telemarketing Services

 

[Lhuffst]

Sorry it took so long to get back. That worked great! thanks