Checkbox and setting values

  • Thread starter Thread starter Sok Hong
  • Start date Start date
S

Sok Hong

I am trying to set 19 seperate check boxes so that when
one of them is clicked, a text string I set will be
entered into the set table field.

For example, I set "Billing" field as a check box, if the
user checks that box, I would want the code to enter in
the word "Billing" in the set table.

Any clue on how I can get started with that? Is there a
previous article that tells you how to do something like
that?
 
Sok Hong said:
I am trying to set 19 seperate check boxes so that when
one of them is clicked, a text string I set will be
entered into the set table field.

For example, I set "Billing" field as a check box, if the
user checks that box, I would want the code to enter in
the word "Billing" in the set table.

Any clue on how I can get started with that? Is there a
previous article that tells you how to do something like
that?
Click to expand...

Here are some questions to clarify matters:

1. Is the form based on the "set table"?

2. Are the check boxes bound or unbound?

3. Are they mutually exclusive, so that only one may be checked at a
time (as in an option group)?

4. What is the name of the field?

5. Do you want to add the text "Billing" to existing text in this field,
or do you want to replace any text that may already be there?

6. Why not just bind the check boxes (or the option group, if they're
mutually exclusive) to fields in the table, and generate the text via a
calculated control or a calculated field in a query, whenever you need
it?
 
1. Yes, it's based on a "set Table"
2. I think they are bound
3. Multiple check boxes are allowed
4. Each check box has a different name for the field, the
first one is called Check76
5. Want to add word "Billing" to the existing text, not
replace
6.
 
Sok Hong said:
1. Yes, it's based on a "set Table"
Click to expand...

What is the actual name of the table? (Translate to English if
necessary) That will give us a specific name we can refer to.
2. I think they are bound
Click to expand...

Do you know what I mean by "bound"? I mean that the check box has a
field from the table as its Control Source, so that changes to the check
box control on the form are reflected in that field in the table. With
that in mind, please confirm that the check boxes are bound; that is,
that each check box control has a Control Source property that is the
name of a field in your form's underlying table.
3. Multiple check boxes are allowed
Click to expand...
4. Each check box has a different name for the field, the
first one is called Check76
Click to expand...

That sounds like a name for a check box *control*, but not a plausible
name for a *field*. Don't confuse controls, which are user-interface
elements on forms or reports, with fields, which are elements of tables
that store data. A control may be bound to a field, but they are not
technically the same thing. I was asking about the name of the field in
which you want the text, "Billing" in your example, to appear.

I'm still not sure I understand what you have and what you want. I
think it would be best if you would post the table definition, as well
as a description of the form, including its Record Source property and
the relevant controls on the form.
 
Back
Top