Hi,

Don't know if this is the right place but I have a check box within a table. When there is a cross in the check box, I want to omit records within my script. I have tried to do this by constraining my found set but I don't seem to be able to get the syntax correct.

Should I have the checkbox field formatted as number?

What is the syntax for omitting the boxes that are checked?

If this is in the wrong place, do tell me where I should put it (clean answers only please!)

Many thanks

It's a matter of convenience, but if you make a valuelist with the number 1 as the only member, can you when entering the field to the layout redraw it so only the box is visible. When you turn to the script can your looping contain:

If(checkbox)

Omit

end if

But this isn't particular fast compared to the Jeff Almquist method, I here have made a template to demonstrate.

http://accessvbsqladvisor.com/doc/04565

--sd

Sari2.zip

I couldn't get this to work but in the end constrained my found set by omitting records where the checkbox had a character in it. I tried to look up your link but had difficulty with it.

Many thanks anyway.

Ah! so you got a found set in the first place, and then wish to omit the ones checked just after first seach.

Then is the script

Enter Find Mode

Constrain Found Set[Restore]

...where your request in this request is set to Omit records and in the box write the value 1, if thats what the value the checkbox contains.

--sd

Sari3.zip