Ofer said:To continue my question from you previous post.
Are we talking about a continous form, with a check box field
If so, you can create a text field in the form footer that has
=Sum(IIf([CheckBoxFieldName]=True,1,0))
in the ControlSource Property
MaryBethK said:Is there a way to have a field keep track of how may boxes you select? THis
would need to be without selecting them all and without having each form have
the same boxes checked.
MaryBethK said:Ok, I'll ask the dumb question, how do I know if its a continous form? Also
do I have to label my field "check box"
Ofer said:To continue my question from you previous post.
Are we talking about a continous form, with a check box field
If so, you can create a text field in the form footer that has
=Sum(IIf([CheckBoxFieldName]=True,1,0))
in the ControlSource Property
MaryBethK said:Is there a way to have a field keep track of how may boxes you select? THis
would need to be without selecting them all and without having each form have
the same boxes checked.
Ofer said:Let me ask first, what do you mean by saying each form, how many forms are
open?
Are wa talking about one forms with the records repeating them self, so it
looks like alot of forms conected to each other
MaryBethK said:Ok, I'll ask the dumb question, how do I know if its a continous form? Also
do I have to label my field "check box"
Ofer said:To continue my question from you previous post.
Are we talking about a continous form, with a check box field
If so, you can create a text field in the form footer that has
=Sum(IIf([CheckBoxFieldName]=True,1,0))
in the ControlSource Property
:
Is there a way to have a field keep track of how may boxes you select? THis
would need to be without selecting them all and without having each form have
the same boxes checked.
MaryBethK said:By each form I mean my continuous forms. I have 4 tables connected to one
form. I have an Events field for participants in our organization. I have
about 30 event and I want to have check boxes for each different event. Im
wanting to have the field record each box that I check per-entry. The 1st
time I tried it each entry had the same check boxes, then I tried what you
said and now all the boxes get checked when i click on one, the only
difference is it doesn't apply to every entry. What am I not doing or doing
wrong?
Ofer said:Let me ask first, what do you mean by saying each form, how many forms are
open?
Are wa talking about one forms with the records repeating them self, so it
looks like alot of forms conected to each other
MaryBethK said:Ok, I'll ask the dumb question, how do I know if its a continous form? Also
do I have to label my field "check box"
:
To continue my question from you previous post.
Are we talking about a continous form, with a check box field
If so, you can create a text field in the form footer that has
=Sum(IIf([CheckBoxFieldName]=True,1,0))
in the ControlSource Property
:
Is there a way to have a field keep track of how may boxes you select? THis
would need to be without selecting them all and without having each form have
the same boxes checked.
Ofer said:It sound like the field (check box) in the form is not bounded to a field in
the table, when a field is not bounded in a continus form, the selection will
applay to all the forms.
MaryBethK said:By each form I mean my continuous forms. I have 4 tables connected to one
form. I have an Events field for participants in our organization. I have
about 30 event and I want to have check boxes for each different event. Im
wanting to have the field record each box that I check per-entry. The 1st
time I tried it each entry had the same check boxes, then I tried what you
said and now all the boxes get checked when i click on one, the only
difference is it doesn't apply to every entry. What am I not doing or doing
wrong?
Ofer said:Let me ask first, what do you mean by saying each form, how many forms are
open?
Are wa talking about one forms with the records repeating them self, so it
looks like alot of forms conected to each other
:
Ok, I'll ask the dumb question, how do I know if its a continous form? Also
do I have to label my field "check box"
:
To continue my question from you previous post.
Are we talking about a continous form, with a check box field
If so, you can create a text field in the form footer that has
=Sum(IIf([CheckBoxFieldName]=True,1,0))
in the ControlSource Property
:
Is there a way to have a field keep track of how may boxes you select? THis
would need to be without selecting them all and without having each form have
the same boxes checked.
MaryBethK said:So is there a way i can make this work?
Ofer said:It sound like the field (check box) in the form is not bounded to a field in
the table, when a field is not bounded in a continus form, the selection will
applay to all the forms.
MaryBethK said:By each form I mean my continuous forms. I have 4 tables connected to one
form. I have an Events field for participants in our organization. I have
about 30 event and I want to have check boxes for each different event. Im
wanting to have the field record each box that I check per-entry. The 1st
time I tried it each entry had the same check boxes, then I tried what you
said and now all the boxes get checked when i click on one, the only
difference is it doesn't apply to every entry. What am I not doing or doing
wrong?
:
Let me ask first, what do you mean by saying each form, how many forms are
open?
Are wa talking about one forms with the records repeating them self, so it
looks like alot of forms conected to each other
:
Ok, I'll ask the dumb question, how do I know if its a continous form? Also
do I have to label my field "check box"
:
To continue my question from you previous post.
Are we talking about a continous form, with a check box field
If so, you can create a text field in the form footer that has
=Sum(IIf([CheckBoxFieldName]=True,1,0))
in the ControlSource Property
:
Is there a way to have a field keep track of how may boxes you select? THis
would need to be without selecting them all and without having each form have
the same boxes checked.
Ofer said:Do you want to save this selection in a table?
If so, to which tables the form is bounded to, what is the record source of
e form.
Does the check box has a field that is dedicated to the check box in the form?
Did you lose me now?
MaryBethK said:So is there a way i can make this work?
Ofer said:It sound like the field (check box) in the form is not bounded to a field in
the table, when a field is not bounded in a continus form, the selection will
applay to all the forms.
:
By each form I mean my continuous forms. I have 4 tables connected to one
form. I have an Events field for participants in our organization. I have
about 30 event and I want to have check boxes for each different event. Im
wanting to have the field record each box that I check per-entry. The 1st
time I tried it each entry had the same check boxes, then I tried what you
said and now all the boxes get checked when i click on one, the only
difference is it doesn't apply to every entry. What am I not doing or doing
wrong?
:
Let me ask first, what do you mean by saying each form, how many forms are
open?
Are wa talking about one forms with the records repeating them self, so it
looks like alot of forms conected to each other
:
Ok, I'll ask the dumb question, how do I know if its a continous form? Also
do I have to label my field "check box"
:
To continue my question from you previous post.
Are we talking about a continous form, with a check box field
If so, you can create a text field in the form footer that has
=Sum(IIf([CheckBoxFieldName]=True,1,0))
in the ControlSource Property
:
Is there a way to have a field keep track of how may boxes you select? THis
would need to be without selecting them all and without having each form have
the same boxes checked.
MaryBethK said:I do want to save 'these' selections in the table. I do have a field (events)
that is dedicated to the check boxes. I just cant figure out how to have the
events field keep track of what boxes are clicked per entry.
Ofer said:Do you want to save this selection in a table?
If so, to which tables the form is bounded to, what is the record source of
e form.
Does the check box has a field that is dedicated to the check box in the form?
Did you lose me now?
MaryBethK said:So is there a way i can make this work?
:
It sound like the field (check box) in the form is not bounded to a field in
the table, when a field is not bounded in a continus form, the selection will
applay to all the forms.
:
By each form I mean my continuous forms. I have 4 tables connected to one
form. I have an Events field for participants in our organization. I have
about 30 event and I want to have check boxes for each different event. Im
wanting to have the field record each box that I check per-entry. The 1st
time I tried it each entry had the same check boxes, then I tried what you
said and now all the boxes get checked when i click on one, the only
difference is it doesn't apply to every entry. What am I not doing or doing
wrong?
:
Let me ask first, what do you mean by saying each form, how many forms are
open?
Are wa talking about one forms with the records repeating them self, so it
looks like alot of forms conected to each other
:
Ok, I'll ask the dumb question, how do I know if its a continous form? Also
do I have to label my field "check box"
:
To continue my question from you previous post.
Are we talking about a continous form, with a check box field
If so, you can create a text field in the form footer that has
=Sum(IIf([CheckBoxFieldName]=True,1,0))
in the ControlSource Property
:
Is there a way to have a field keep track of how may boxes you select? THis
would need to be without selecting them all and without having each form have
the same boxes checked.
Ofer said:Would you like to post your MDB, I can have a look at it.
You can send it to
(e-mail address removed)
Change the name from MDBName.Mdb to MDBName.JPG
Hotmail doesn't allow mdb attachment.
run compact on the mdb or better zip it, I have a limit of 2 MB
MaryBethK said:I do want to save 'these' selections in the table. I do have a field (events)
that is dedicated to the check boxes. I just cant figure out how to have the
events field keep track of what boxes are clicked per entry.
Ofer said:Do you want to save this selection in a table?
If so, to which tables the form is bounded to, what is the record source of
e form.
Does the check box has a field that is dedicated to the check box in the form?
Did you lose me now?
:
So is there a way i can make this work?
:
It sound like the field (check box) in the form is not bounded to a field in
the table, when a field is not bounded in a continus form, the selection will
applay to all the forms.
:
By each form I mean my continuous forms. I have 4 tables connected to one
form. I have an Events field for participants in our organization. I have
about 30 event and I want to have check boxes for each different event. Im
wanting to have the field record each box that I check per-entry. The 1st
time I tried it each entry had the same check boxes, then I tried what you
said and now all the boxes get checked when i click on one, the only
difference is it doesn't apply to every entry. What am I not doing or doing
wrong?
:
Let me ask first, what do you mean by saying each form, how many forms are
open?
Are wa talking about one forms with the records repeating them self, so it
looks like alot of forms conected to each other
:
Ok, I'll ask the dumb question, how do I know if its a continous form? Also
do I have to label my field "check box"
:
To continue my question from you previous post.
Are we talking about a continous form, with a check box field
If so, you can create a text field in the form footer that has
=Sum(IIf([CheckBoxFieldName]=True,1,0))
in the ControlSource Property
:
Is there a way to have a field keep track of how may boxes you select? THis
would need to be without selecting them all and without having each form have
the same boxes checked.
MaryBethK said:I emailed my MDB to you. Hopefully you can fugure out what I'm doing wrong.
Ofer said:Would you like to post your MDB, I can have a look at it.
You can send it to
(e-mail address removed)
Change the name from MDBName.Mdb to MDBName.JPG
Hotmail doesn't allow mdb attachment.
run compact on the mdb or better zip it, I have a limit of 2 MB
MaryBethK said:I do want to save 'these' selections in the table. I do have a field (events)
that is dedicated to the check boxes. I just cant figure out how to have the
events field keep track of what boxes are clicked per entry.
:
Do you want to save this selection in a table?
If so, to which tables the form is bounded to, what is the record source of
e form.
Does the check box has a field that is dedicated to the check box in the form?
Did you lose me now?
:
So is there a way i can make this work?
:
It sound like the field (check box) in the form is not bounded to a field in
the table, when a field is not bounded in a continus form, the selection will
applay to all the forms.
:
By each form I mean my continuous forms. I have 4 tables connected to one
form. I have an Events field for participants in our organization. I have
about 30 event and I want to have check boxes for each different event. Im
wanting to have the field record each box that I check per-entry. The 1st
time I tried it each entry had the same check boxes, then I tried what you
said and now all the boxes get checked when i click on one, the only
difference is it doesn't apply to every entry. What am I not doing or doing
wrong?
:
Let me ask first, what do you mean by saying each form, how many forms are
open?
Are wa talking about one forms with the records repeating them self, so it
looks like alot of forms conected to each other
:
Ok, I'll ask the dumb question, how do I know if its a continous form? Also
do I have to label my field "check box"
:
To continue my question from you previous post.
Are we talking about a continous form, with a check box field
If so, you can create a text field in the form footer that has
=Sum(IIf([CheckBoxFieldName]=True,1,0))
in the ControlSource Property
:
Is there a way to have a field keep track of how may boxes you select? THis
would need to be without selecting them all and without having each form have
the same boxes checked.