Check Boxes in Subform

  • Thread starter Thread starter Susan Medina
  • Start date Start date
S

Susan Medina

Hi,

I have a tab control with a subform that has multiple
check boxes. When I select a check box, the checkmark
appears and IS RECORDED IN THE RELATED TABLE. But when I
close the record, and later reopen it, the checkmark does
not appear! I thought perhaps my selection was deleted
upon closing the record, but when I looked at the table,
the information (the selection) is still there.

Does anyone know why the checkmark is 'disappearing'in the
subform when I close the record? And how I can fix this?

Although I'm happy that the information stays in the
table, I need to be able to see it in form view as well!!!
 
Check the OnOpen, OnLoad, OnCurrent and other events of the form. Make sure
there is no code that is setting the checkbox to No (or False, or 0).

Tony
 
Is the subform bound to the table, or are you using code to save the
data. If the latter, you will also need code to retrieve the data

other possibilities...
The subform shows multiple records. Depending on how you have set it
up, it may not be showing the same record when you open it as when you
closed it.

For example, you may not have the Child -Master relationship set up
correctly - this defines what reords in the sub form belong to the
record in the main form
Try changing the Subforms default display mode to DataSheet or
continuous forms. This will show up if the Subform has multipe
records.

You may have DataEntry set on the sub form. This will mean that the
Subform will always show a new record when you open it

Regards Greg Kraushaar
Wentworth Falls Australia
(Do not email - the reply address is a Spam spoofer)
(If you really must, remove all UCase and numbers)
 
Back
Top