Check box for user input 1

[Loktar]

Hello everyone,

I have a fairly simple question that's been baffling me since I started using Access. I have a continuous form and I want to place a check box along with each record. I don't want this value bound to anything, instead I want to use it for user input. The user checks the box next to the records they want to see more info on, clicks a command button and a report comes up showing just the checked records.

The problem that I have is I can't figure any way to let the check box stand on its own. I've used them before when they are bound to a field in a table/query, and that works just fine, but in this case I want them to be unbound and be used simply for user input.

Once I get this figured out I can do the rest, but I've tried to solve this off and on for a while with no luck...

Thanks in advance for any tips you can give me.

 

[lupins46]

You can't use an unbound check box in this way.
On a continuous form the value ofthe checkbox is always the same for all of the records.
You will have to add a yes/no field to the table.

 

[Loktar]

I was hoping that I didn't have to do it this way...oh well. Thanks for the input tho, now I can stop banging my head into a wall

 

[missinglinq]

Do you have a textbox without anything tied to its Double Click event? Maybe you could use this to pull up your additional info. I use this technique to Double Click on a date field and bring up a Calendar for the user to use to input the date. I think it'll also work on the continous form.

The Missinglinq

"It's got to be the going,
not the getting there that's good!"
-Harry Chapin

 

[Loktar]

I ended up using text boxes in place of check boxes before on my continuous forms, and that's what I did on this one too. I've never had to use double click tho; single click always worked fine for me

 

[missinglinq]

How do you click into the text box (single click) to enter text if you have On Click set to do something else? Just curious.

The Missingling

"It's got to be the going,
not the getting there that's good!"
-Harry Chapin

 

[Loktar]

Oh, I only use them as check boxes, not for typing in. I turn all the editing options off and use them as if they were buttons/check boxes. Being able to enter data and double click would confuse my poor users too much ;-)

 

[missinglinq]

I see" said the blind man, as he picked up his saw and went!

The Missinglinq

"It's got to be the going,
not the getting there that's good!"
-Harry Chapin