CheckBox question?

[Franknstuff]

This is driving me crazy. I have check boxes that are in a combo box. They are not bound. All I want is to uncheck a box.

 

[WayneRyan]

F,

Do you mean that one of the columns that your combo-box displays is
boolean?

You can't edit the values that a combo presents. They may be based
on a table/query, but even if you could change them, the underlying
data wouldn't reflect it.

You can have one column of your combo bound to a control, but you can
only select values into it from the combos RowSource.

Wayne

 

[Franknstuff]

Thanks for responding

I have assigned a action to each checkbox, what I want to do is, when that action is done to remove the check mark thats in the box.

 

[WayneRyan]

F,

You unbound combo can be used to select a record to be
displayed on an Access form. The form has the ability
to let the user change the checkbox(s).

Wayne

 

[Franknstuff]

okay

But, I still need to know how to uncheck a check box using the program.

 

[Franknstuff]

Buttons?

I could use buttons, but I would prefer using Check boxes.

 

[WayneRyan]

F,

Let's take it from the top.

1) You have a table of information for employees and things they have
to do.

2) When they accomplish a specific thing, you want to show that
in a checkbox.

3) To reflect a data change, you can basically use an Access form,
or go directly to the table. We don't want to go the table route so
we can have the wizard make a data entry form for our table.

4) Now, if you're patient enough, you can use that form to check or
uncheck the appropriate checkboxes. Not efficient, but workable.

5) You can then add an "unbound" combo-box to your form. To keep
it simple, it displays an employee name and one of the "ToDo" checkboxes.
Note that it DISPLAYS them, you can't edit them on the combo. What
we need is for the FORM to get in synch with the combo.

6) Base your form on a query. The query just gets records from your
table, BUT in the Criteria section for the Name field:

=Forms![YourForm]![YourCombo]

7) Then, whenever they select something from the combo, Requery
the form, and then you can edit your data.

That's a lot of words, and it's really easier to do than describe. Get started
on it and post back, we'll get you there.

Wayne

 

[Franknstuff]

Let's see

I'm much better using visual aids.

I have a form and in this form is a subform as the person scrolls through the records of the sub form a check box appears if there is relevent information. The person clicks on the check box and goes to the next record. I could add a (yes/no) column to the DB, but I rather just run some VB code then un-check the check box when you go to the next record. Everything works fine except that the check box remains checked when they go to the next record.

 

[WayneRyan]

F,

You don't really need VB.

Just post what you have, AND what you would like it to do.

Wayne

 

[Franknstuff]

Here is a example I think

I hope I did this right.

 

[WayneRyan]

Frank,

I made a little demo for you. It's not fancy, but we need a starting point.

Check it out & we'll see what happens.

Wayne

 

[Franknstuff]

Alright

Ok you assigned the stauts to a Table, is there a way, without bounding to a table , to set chekbox1 as default value for each record?

 

[Franknstuff]

I think I have it

If I set checkbox 1 as .Visible=false and set Status value to checkbox 1
then know visible check box would appear in the status box.

 

[Franknstuff]

Sorry

Thanks for your help. I guess I just needed to think a little out side the box.

 

[WayneRyan]

Frank,

The example I sent you used an option group.

The status field can have one of three Values (1, 2, 3).
1 - New
2 - In Progress
3 - Completed

The option group defaults to 1 (New) for new records.

Regardless of whether you use an option group or an individual checkbox,
the FORM must be used to edit it. One of the combos on the right-hand
side of the form can DISPLAY it, but you can only change it with the form.

I just used a form created by the Wizard, its just a starting point.

Experiment with it a bit and post back.

Wayne

 

[Franknstuff]

This is an example

This is what I wanted it to do. Visually no check boxes are checked then you check one and go to next record and visually no check boxes are checked. It gives the appearence that the check buttons where reset between records.