I have changed the control source on many checkboxes. How do I still have
the data show up in my table so I can run a report, or how can I run a report
off of a form? Or how can I keep the control source the same but have an if
statement along with it?
Thanks
Chey

If the checkbox has a control source of a field in a table, then when you
change the value in the checkbox on a form, it will update the underlying
field value in the table.

Then, simply pull that field from the table to your report, or create a
checkbox on your report and make the source your field in your table.

--
Rick B



"Chey" <(E-Mail Removed)> wrote in message
news:FDE775DE-3B8D-4DD7-AD90-(E-Mail Removed)...
>I have changed the control source on many checkboxes. How do I still have
> the data show up in my table so I can run a report, or how can I run a
> report
> off of a form? Or how can I keep the control source the same but have an
> if
> statement along with it?
> Thanks
> Chey
>
>

I realize that part, but that is my problem.
I have changed the control source of a check box to
IIF([Text123]="OK",True,False)
But now when it is checked it doesn't reflect in the table.
The only way it will check is when the control source matches the table name.
Which makes sense. But how do I continue to have my iif statement and still
have it reflect in the table? I hope this make sense.
Or am I writting the iif statement wrong?
As of now the form looks good, but the table doesen't reflect what the for
shows.
Thanks for all your help.

"Rick B" wrote:

>
> If the checkbox has a control source of a field in a table, then when you
> change the value in the checkbox on a form, it will update the underlying
> field value in the table.
>
> Then, simply pull that field from the table to your report, or create a
> checkbox on your report and make the source your field in your table.
>
> --
> Rick B
>
>
>
> "Chey" <(E-Mail Removed)> wrote in message
> news:FDE775DE-3B8D-4DD7-AD90-(E-Mail Removed)...
> >I have changed the control source on many checkboxes. How do I still have
> > the data show up in my table so I can run a report, or how can I run a
> > report
> > off of a form? Or how can I keep the control source the same but have an
> > if
> > statement along with it?
> > Thanks
> > Chey
> >
> >
>
>
>

Is [Text123] a field in your table or is it just an unbound text box on your
form. If it is a field, then you don't need to also store the checkbox, you
already have the "ok" stored. also storing the checkbox value would be
redundant.

If it is an unbound text box, then get rid of it. Just have the user check
the box if they want to indicate a true value.

Where are you putting the IIF statement? You can't put it in the checkbox
control source - that's where the field name would go so the value can be
stored. You could write code to look at the entry in [Text123] and then
check or uncheck the checkbox, but again, that is redundant.

--
Rick B



"Chey" <(E-Mail Removed)> wrote in message
news:BA89AD18-B890-42D0-A854-(E-Mail Removed)...
>I realize that part, but that is my problem.
> I have changed the control source of a check box to
> IIF([Text123]="OK",True,False)
> But now when it is checked it doesn't reflect in the table.
> The only way it will check is when the control source matches the table
> name.
> Which makes sense. But how do I continue to have my iif statement and
> still
> have it reflect in the table? I hope this make sense.
> Or am I writting the iif statement wrong?
> As of now the form looks good, but the table doesen't reflect what the for
> shows.
> Thanks for all your help.
>
> "Rick B" wrote:
>
>>
>> If the checkbox has a control source of a field in a table, then when you
>> change the value in the checkbox on a form, it will update the underlying
>> field value in the table.
>>
>> Then, simply pull that field from the table to your report, or create a
>> checkbox on your report and make the source your field in your table.
>>
>> --
>> Rick B
>>
>>
>>
>> "Chey" <(E-Mail Removed)> wrote in message
>> news:FDE775DE-3B8D-4DD7-AD90-(E-Mail Removed)...
>> >I have changed the control source on many checkboxes. How do I still
>> >have
>> > the data show up in my table so I can run a report, or how can I run a
>> > report
>> > off of a form? Or how can I keep the control source the same but have
>> > an
>> > if
>> > statement along with it?
>> > Thanks
>> > Chey
>> >
>> >
>>
>>
>>

this might sound bad but it is to much work to check the boxes.
I have a form where I enter in numbers. If the numbers equal a certain
amount then I want the box to check. So yes Text123 is an unboud field.
Depending on the total it checks multiple boxes. I enter in up to 12 numbers.
When I enter in the first number it checks a box saying they turned in a bill
If it totals a certain number then it checks another box.
How can I easily do this.
I have over 5 different boxes that could be checked depending on the outcome
of a total. How do I write the code to look at the fields to determin true
of false?


"Rick B" wrote:

> Is [Text123] a field in your table or is it just an unbound text box on your
> form. If it is a field, then you don't need to also store the checkbox, you
> already have the "ok" stored. also storing the checkbox value would be
> redundant.
>
> If it is an unbound text box, then get rid of it. Just have the user check
> the box if they want to indicate a true value.
>
> Where are you putting the IIF statement? You can't put it in the checkbox
> control source - that's where the field name would go so the value can be
> stored. You could write code to look at the entry in [Text123] and then
> check or uncheck the checkbox, but again, that is redundant.
>
> --
> Rick B
>
>
>
> "Chey" <(E-Mail Removed)> wrote in message
> news:BA89AD18-B890-42D0-A854-(E-Mail Removed)...
> >I realize that part, but that is my problem.
> > I have changed the control source of a check box to
> > IIF([Text123]="OK",True,False)
> > But now when it is checked it doesn't reflect in the table.
> > The only way it will check is when the control source matches the table
> > name.
> > Which makes sense. But how do I continue to have my iif statement and
> > still
> > have it reflect in the table? I hope this make sense.
> > Or am I writting the iif statement wrong?
> > As of now the form looks good, but the table doesen't reflect what the for
> > shows.
> > Thanks for all your help.
> >
> > "Rick B" wrote:
> >
> >>
> >> If the checkbox has a control source of a field in a table, then when you
> >> change the value in the checkbox on a form, it will update the underlying
> >> field value in the table.
> >>
> >> Then, simply pull that field from the table to your report, or create a
> >> checkbox on your report and make the source your field in your table.
> >>
> >> --
> >> Rick B
> >>
> >>
> >>
> >> "Chey" <(E-Mail Removed)> wrote in message
> >> news:FDE775DE-3B8D-4DD7-AD90-(E-Mail Removed)...
> >> >I have changed the control source on many checkboxes. How do I still
> >> >have
> >> > the data show up in my table so I can run a report, or how can I run a
> >> > report
> >> > off of a form? Or how can I keep the control source the same but have
> >> > an
> >> > if
> >> > statement along with it?
> >> > Thanks
> >> > Chey
> >> >
> >> >
> >>
> >>
> >>
>
>
>

right click on the collumn you want to sort and click on sort alphabetically

"Chey" wrote:

> I have changed the control source on many checkboxes. How do I still have
> the data show up in my table so I can run a report, or how can I run a report
> off of a form? Or how can I keep the control source the same but have an if
> statement along with it?
> Thanks
> Chey
>
>