Results 1 to 9 of 9
  1. #1
    Join Date
    Mar 2004
    Posts
    36

    Unanswered: New Form Query (Access 97)

    Hello,

    I'm currently building a new form and am unsure how to do the following -

    Depending on what option I choose within ComboBox1 I want only certain data available in ComboBox2.

    i.e. If I selected 'Day of week' in Combo1 I would only want 'Monday', Tuesday' etc available in combo2. But if I selected 'Month' in combo1 then I would only want 'Jan', 'Feb', etc available in Combox2.

    I'd be very grateful if anyone has ideas on how I can do this.

    Thanks

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Check this
    Attached Files Attached Files

  3. #3
    Join Date
    Mar 2004
    Posts
    36

    Talking

    Thank you very much, that's exactly what I'm looking for!!!

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Never mind, good luck

  5. #5
    Join Date
    Mar 2004
    Posts
    36
    Hi

    I'd like to expand on this further and create a 3rd combo box with data being available depending on what was chosen in the 2nd combo box.

    I.e. if I select 'Day of Week' in combo1 and then get 'Monday'. 'Tuesday' etc in combo2 I then want to be able to select 'AM', 'PM' in combo3

    But then

    If I select 'Month' in combo1 and then select 'Jan', 'Feb' etc in combo2 could I then get 'Mid Month', 'End Month' available in combo3.

    Thanks

  6. #6
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Quote Originally Posted by hammbakka
    Check this
    Just wait I'll send you an example

  7. #7
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Check this example, I used List boxex instead of Combo Boxes
    Attached Files Attached Files

  8. #8
    Join Date
    Mar 2004
    Posts
    36

    Thumbs up

    Thank you very much, it's exactly what I'm looking for!

  9. #9
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Good that it functions

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •