help on check boxes please.

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

HI,

I need to have few check boxes on a form and have some
text, a different text for each check box to be diplayed
in a report upon checking the check boxes and having
report created. Please help since I haven't worked with
check boxes and i don't know if this is possible at all.

Thank you in advance.

Mike
 
HI,

I need to have few check boxes on a form and have some
text, a different text for each check box to be diplayed
in a report upon checking the check boxes and having
report created. Please help since I haven't worked with
check boxes and i don't know if this is possible at all.
Click to expand...

A checkbox is a *tool*. It's not data. The data is stored (if at all)
in your Table.

What are your table structures? How can you determine what text to
display?
 
I was hoping to be able to store my text wich is in the
form of an address for a job location in a table and then
create a query based on that table and take it from there.

Is there anyother anternative to this check box approach?

I guess I need to do a better job explaning this.!

thx,

Mike
 
I was hoping to be able to store my text wich is in the
form of an address for a job location in a table and then
create a query based on that table and take it from there.

Is there anyother anternative to this check box approach?
Click to expand...

One good way would be to store a small table with two fields - an
integer, 1 to n, and n text messages. An Option Group control on your
form could have checkboxes or radio buttons with values from 1 to n;
you could then use a Query on the text table's numeric field of

=[Forms]![NameOfYourForm]![NameOfTheOptionGroup]

to select the desired message.
 
John,

Can you please be a little more specific.

I think, I'm not clear about the table, can you please be
specific about the feilds on this table and the relation
of the number integer and the text feild.

n = number of text feilds that I want to have in my
table, i.e. say, 4 addressess, correct? then what is the
integer number for?

Thanks,

Mike
-----Original Message-----
I was hoping to be able to store my text wich is in the
form of an address for a job location in a table and then
create a query based on that table and take it from there.

Is there anyother anternative to this check box
Click to expand...
approach?

One good way would be to store a small table with two fields - an
integer, 1 to n, and n text messages. An Option Group control on your
form could have checkboxes or radio buttons with values from 1 to n;
you could then use a Query on the text table's numeric field of

=[Forms]![NameOfYourForm]![NameOfTheOptionGroup]

to select the desired message.


.
Click to expand...
 
Back
Top