Hello All:

I am having a rough day today because I cant figure this out:

I have a field in a database that is a text field. It is pulling from a value list of Yes and No. When the user completes the search and the click on a button to start another search, i need to clear the check boxes in the table. They are for reference only.

I can get this to happen by using setfield= "". That works well on the first record in the table, but i can not seem to get it to loop correctly and remove all check boxes.

Any thought?

Thanks

Lakota

Hi Lakota,

This should do it for you.

Go to Record/Request/Page

[ First ]

Loop

Set Field [ YourFieldHere , "" ]

Go to Record/Request/Page

[ Next, Exit after last ]

End Loop

HTH

Lee

If you do a Loop, you might want a Freeze Window before it starts, it can speed up loops a lot. An alternative to the Loop/Set Field is the Replace command. Note that both Replace and Set Field can potentially generate an error in a multi-user environment, if the record you're trying to modify is already in use by another user.

Fitch and Lee:

Thank you both for your help with this. It seems to work for the first record only. Not sure why. I am using a portal (did not mention that before_ SORRY), so i switched it around a bit to look at the first portal row, but even that did not work.

Any thoughts?

Thanks

Lakota

Lakota said:

I am using a portal (did not mention that before_ SORRY), so i switched it around a bit to look at the first portal row, but even that did not work.

You have (at least) two tables, which are related