I've made a check box for yes or no on my report layout. The people using this particular layout currently have just a guest account because I only wanted them to view the reports. Now I want them to be able to click a yes or no box. Is there a way to just give them access to one item?

Hi

place squares over that check box set and set them to work like buttons ( they'll fire script with full access account )

I placed the square over the check box and made it a button. Do I also have to make it perform a script. If so I do I make a script select the button for yes or no.

1) Set your checkbox to be a number with values 1 or 0

2) format that number field to show boolean data with Yes ( for not zero values ) and No ( for zero or empty values )

3) Yes, those squares must fire a script, something like:

Set Field [ YourTable::YourCheckBoxField ; Abs ( YourTable::YourCheckBoxField - 1 ) ]

Commit Record/Request

( it is better to show ONLY a checkbox )

I'm having trouble with a few parts. You said: Set your checkbox to be a number with values 1 or 0

I went to manage database on my field I chose in range 0 to 1.

Then for your: format that number field to show boolean data with Yes ( for not zero values ) and No ( for zero or empty values )

I made a box and put it as boolean. The boxes has yes and no. Should I change them to something else.

Last: On the script. I chose the set field with my rackedyn but I did not see the ABS in the list to choose from.

I figured it out. Thanks for all the help.

I figured it out but now i do not know how to erase a check box if someone mistakenly hits the button to run the script.

May be this helps...

YesNo.zip