Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Help with Check box and text

Discussion in 'Information Technology' started by AmandaH, Jul 28, 2006.

Tags:
  1. AmandaH

    AmandaH
    Expand Collapse
    Guest

    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
    easy way to do this in Access.

    Thanks,

    ~Amanda~
     
  2. Loading...


  3. Jeff C

    Jeff C
    Expand Collapse
    Guest

    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
    > easy way to do this in Access.
    >
    > Thanks,
    >
    > ~Amanda~
    >
    >
     
  4. AmandaH

    AmandaH
    Expand Collapse
    Guest

    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".
     
  5. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "AmandaH" wrote

    > 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".


    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
     
  6. AmandaH

    AmandaH
    Expand Collapse
    Guest

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

    what needs to go into the [fn]?
     

Share This Page