Help with Check box and text

I am use to using Lotus - 123. What I would like to do with my access
database is two things.

First:
I have 3 check boxes "Aboriginal", "Francophone" and "Women"; they are
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13834-help-with-check-box-and-text.html
linked to the table through a control source. Now in Lotus when I check
"Francophone" (for example) Francophone shows up in the column under
that record in the table, in Access I see a -1. How to I change this to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13834
work as lotus does?

Second:
I already have 400 records in the table that I am linking to, when I
pull up a record if the person is a Francophone I would like the
Francophone check box to be checked. How do I do this?

Lotus makes this really easy and I am thinking/hopping that there is an
easy way to do this in Access.

Thanks,

~Amanda~

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Open your table in Design mode. Put your curser in the yes/no fields you are
concerned with. On the bottom of the screen you will see the attributes of
that field, There is a second tab labeled lookup that needs to have check
box selected.
--
Jeff C
Live Well .. Be Happy In All You Do


"AmandaH" wrote:

> I am use to using Lotus - 123. What I would like to do with my access
> database is two things.
>
> First:
> I have 3 check boxes "Aboriginal", "Francophone" and "Women"; they are
> linked to the table through a control source. Now in Lotus when I check
> "Francophone" (for example) Francophone shows up in the column under
> that record in the table, in Access I see a -1. How to I change this to
> work as lotus does?
>
> Second:
> I already have 400 records in the table that I am linking to, when I
> pull up a record if the person is a Francophone I would like the
> Francophone check box to be checked. How do I do this?
>
> Lotus makes this really easy and I am thinking/hopping that there is an
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13834
> easy way to do this in Access.
>
> Thanks,
>
> ~Amanda~
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13834
>

I found that, but that just changes all of my tect in my table to check
boxs, so I lose all of the information for the 400 records. What would
be ideal is if I could use the Form to see the check box(checked or
unchecked) depding on the respons to the question. In the table it
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13834
would still say " Aboriginal", "Francophone" and/or "Women".
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13834

"AmandaH" wrote
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13834

> I found that, but that just changes all of my tect in my table to check
> boxs, so I lose all of the information for the 400 records. What would
> be ideal is if I could use the Form to see the check box(checked or
> unchecked) depding on the respons to the question. In the table it
> would still say " Aboriginal", "Francophone" and/or "Women".
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13834

Access isn't Lotus 123. It's not even "Microsoft Excel on steroids," though
some would like it to be.

Check boxes are for displaying Yes/No information, so you'd need to do some
manipulation to make them work the way you describe. A calculated Field in
the Query that you use for the RecordSource of your Form, like

AboChk: IIF ([fn] = "Aborignal", True, False)

and then use AboChk as the Control Source of the CheckBox with the label
"Aboriginal".

Larry Linson
Microsoft Access MVP

AboChk: IIF ([fn] = "Aborignal", True, False)
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13834

what needs to go into the [fn]?