1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Two Access Problems

Discussion in 'Microsoft Office Specialist (MOS)' started by Shepherdess, Feb 28, 2008.

  1. Shepherdess

    Shepherdess Bit Poster

    44
    1
    15
    I am preparing a simple database in Access 2003 and have been struggling with two things:

    - I have got two fields in a table, one for Country, the other for County. I wanted to change the form in such a way that if someone chooses England as a Country, only English counties appear. I have tried two methods: one with visible yes/no for certain counties (when country=England, only English counties are visible), the other with message box, e.g. "Fife is not in England", but I can't seem to get it right. Do you think I will have to put English, Scottish, Welsh counties in separate fields (it only just occured to me as an option :-) )?
    - the other problem is with choosing topic. Users will have to choose main category, and then (if they want) choose subcategory. I have created the lookup table for categories, but I am not sure how to set up subcategories.

    I have looked for the answers in two books (one about Access 2003, the other about VBA) and in Office.microsoft.com but could not find anything even remotely relevant. I would not like you to write a code for me, just give me some hints where to look for the answers

    Thanks in advance. :D
     
    WIP: MCSE, MCTS
  2. ThomasMc

    ThomasMc Gigabyte Poster

    1,507
    49
    111
    on the first bit if I have picked you up correctly, you could use filters or a Query/View using your txtbox/combo value as the parameter and the after update event to requery the data
     
    Certifications: MCDST|FtOCC
    WIP: MCSA(70-270|70-290|70-291)
  3. Sparky
    Highly Decorated Member Award

    Sparky Zettabyte Poster Moderator

    10,191
    299
    319
    Certifications: MSc MCSE MCSA:M MCSA:S MCITP:EA MCTS(x5) Security+ Network+ A+
    WIP: Exchange 2007\2010
  4. ThomasMc

    ThomasMc Gigabyte Poster

    1,507
    49
    111
    yeah just like that :rolleyes: :)
     
    Certifications: MCDST|FtOCC
    WIP: MCSA(70-270|70-290|70-291)
  5. Shepherdess

    Shepherdess Bit Poster

    44
    1
    15
    Thanks! :D I am going to sleep now but will play with this tomorrow :-)
     
    WIP: MCSE, MCTS
  6. harpistic

    harpistic Byte Poster

    242
    4
    29
    Use two lookup tables, in the first one have country/country id, in the second one have county, countyid. In the OnChange event for the first combo, set it to combo2.column(x) = the value of the id column of the first one.
     
    Certifications: Pet Geekery
    WIP: cure for insomnia

Share This Page

Loading...