2-part question

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

Hello everybody.

I have a question that is kind of a 2-part question. The thing is that I try
to have the user to be able to "globally" choose from a "settings form" if a
checkbox in a new form would be checked or not by default.

First, in an Access form I want a checkbox thar gets it's default value
(checked or not checked) from a table field (Yes/No) that the user can
choose/change from the earlier mentioned "settings form" so that next new
form always has this checkbox either checked or not checked by default.
Maybe there is a better way to do this than by a table containing this?

Secondly, if this checkbox is checked that means print a copy also for a
report opened from the form, and also if the checkbox is checked, write
"COPY" in a label on the second outprint of the report.

How would I do this? I tried making a Yes/No field in my settings table and
then put as default property of the frame the checkbox is in (yes it's in a
frame for clarity) = [egna_uppgifter]![kopia] but then I can't use it. The
checkbox is grayed out when the form is loading and I can check it but then
no more uncheck it.

Jen
 
Hi Jen,

I'm confused about where things are happening in your last paragraph.
If the checkbox is in a frame then the stored value will be that of the
frame rather than a Boolean value from the checkbox. Once a checkbox is
placed in a frame, checking it will uncheck all other checkboxes in the
frame and the frame will have the value of that checkbox. Most likely
things will work as you expected if you simply remove the frame and place
the checkbox on the form. You could use a rectangle for clarity.

hth
 
Back
Top