check box issues - won't stay checked

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to list items to be checked on a form.
I insert a check box, and give it the label name of the item to chose.
When it is chosen, it does not retain the check on reopen of the data base.

The control source for the box is empty. All I want to do is have a way to
check off items in my form. A list of items with check boxes to verify each
item when the user edits each record.

Is this the way to do this operation easiest ?

Thanks for any help on this....and I can send the DB if anyone needs to see
it.

Joannie
 
I am trying to list items to be checked on a form.
I insert a check box, and give it the label name of the item to chose.
When it is chosen, it does not retain the check on reopen of the data base.

The control source for the box is empty. All I want to do is have a way to
check off items in my form. A list of items with check boxes to verify each
item when the user edits each record.

Is this the way to do this operation easiest ?

Thanks for any help on this....and I can send the DB if anyone needs to see
it.

Joannie
Click to expand...

You first need to add a check box field to your table.
Then, if a query is the form's recordsource, add it from the table to
the query grid also.
Then add the check box to the form.
 
Thanks... I set a control source and the check is now saved, or the empty
check box is saved...however it is edited.
New issue though :) I put the second check box in the form...same control
source (a table), and now BOTH check boxes operate together, not
independently. I'm almost where I need to be if I can get past this last
hurdle I believe. Please bear with my novice questions, and thanks for the
help with this !!

Joannie
 
It sounds like you need a separate table just for your checkbox form. Tie
each checkbox to a different field in the checkbox table.
 
Thanks Karl and Fred.
The table is "software" with several apps listed in the table.
The control source for the check boxes is the "software" table.
But.....how to "tie" the checkbox to the seperate fields (apps) in the table ?
I didn't see an option for this in the properties section of the check box.

tanks agin :)
 
Thanks Karl and Fred.
The table is "software" with several apps listed in the table.
The control source for the check boxes is the "software" table.
But.....how to "tie" the checkbox to the seperate fields (apps) in the table ?
I didn't see an option for this in the properties section of the check box.

tanks agin :)
Click to expand...

Joannie,
I'm confused. :-(

A table cannot be the control source of a check box.
The control source must be a field in the table.

Let's start all over again.

In your underlying TABLE (named "Software") there should be a Yes/No
FIELD named "Selection". ("Selection" is my generic field name. You
can name it anything suitable that you wish.)
To add a field to your table, open the table in Table Design View.
Under the last field in the table, write
Selection
Then in the Datatype column, write
Yes/No

Save the table change.

Next.....
If the Software table is the recordsource for the form, delete the
current check box(es) from your form.
From the Form's Field List tool button, drag the [Selection] field
onto your form.

If a Query is the form's recordsource, in Query Design View drag the
[Selection] field from the Table list of fields onto the query grid.
Save the query.
Then, in Form Design View, using the Field List tool button, drag
the [Selection] field onto your form.

That should be all you need do.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Checked box automatically checks for subsequent records 7
Combo Box and Allow Full Menus 1
Access Cannot select items in listbox 1
Check List Report 4
Copying List box values/selection to a database of sorts 2
Using Check Boxes to select items in an Access subform. 0
Check Boxes 2
Count Check Box 1

Back
Top