Hi Damian,

You wouldn't add two checkboxes, this is a two-way decision - Include or Exclude - and you only need one checkbox.

The default is to exclude the temporary rooms. If that's the report that's going to be generated most often then leave it as the default and add a single (unticked) checkbox to modify that behaviour.

You could modify the SQL like this

Where IIF(Thisform.chkIncludeTempRooms.Value, .T., roomsummary_vp.rmnum > 0)

or something like that.

Regards,

Liam

>i created a form that gives me the choice of selecting whether or not i want to report on Vacant, closed, occupied, or All rooms in a view that has a list of rooms (like a motel) in it. all for choices from the option group, call the same report. Most of my code to do this is in the Click event of the print button. all that works fine. now i need to add a checkbox so that i can
>include/exclude temporary rooms, I.e. rooms with a number less than zero.
>The default is not to include them in the report. So if the checkbox is not
>checked, the room number must be greater than zero. this seems easy as compared to what i just went through, but, my brain must be fried. if i had 2 checkboxes, chkExclude and chkInclude, how can i code this? should it go in the init of the form itself? should it look something like this
>(IF chkExclude = .t.
>roomsummary_vp.rmnum > 0)?
>i don't even know. any help, as detailed and in laymans terms as possible, would be appreciated. thank you.
>damian kemper
>michael_damian_73@msn.com