July 17, 200520 yr 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.
July 17, 200520 yr 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
July 17, 200520 yr Author 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, 200520 yr by Guest
July 17, 200520 yr 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
Create an account or sign in to comment