uncheck a checkbox?

[Stuff5]

Hello guys,

Its my first post in here and im looking for your help.

Im working on a form View and i have designed a database for keeping details of customers of our company (around 8500 records).

In order to print some selections of these records i have defined a temp. checkbox field, so as to use it for my find criteria.

My question is that i want by pressing a button to uncheck any "checked" box within these 8500 records. I managed to do for 1 record but not through all the entries.

[Lee Smith]

Since you know how to do it with one, try this Loop Script with it and see if it does it.

Freeze Window

Go to Record/Request/Page [ First ]

Loop

Set Field [ YourCheckBoxField; "0" ]

Go to Record/Request/Page [ Next; Exit after last ]

End Loop

HTH

Lee

[Stuff5]

I didnt even think to use the Freeze Window, but stills dont understand the use of it; ill look the documentation. However... Perfect! Its working great

Thank you Mr Lee

Edited July 17, 2005 by Guest

[-Queue-]

I would use Set Field [CBfield; ""], so that you do not put invalid data into the field. Otherwise, when you next select an item in the field formatted as a checkbox, it will be entered as

0

SomeItem

instead of only

SomeItem

[Stuff5]

I guess it works the similar way isnt it?