Results 1 to 10 of 10
  1. #1
    Join Date
    Mar 2009
    Posts
    16

    Unanswered: Multiple combo boxes HELP

    Hi,

    I have 90 combo boxes using the same data source. When I select a name in one box all the boxes select it as well. Please help

    johnathon

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Welcome to the forums

    I have to ask; what on earth do you need 90 boxes for?!

    As for the mysterious behavior, if they're all referencing the same data source, yes, they will all change at once as they are all essentially clones of each other. If you don't want this, they must not have the same data source.
    Me.Geek = True

  3. #3
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    Quote Originally Posted by jtpc
    I have 90 combo boxes using the same data source. When I select a name in one box all the boxes select it as well. Please help
    Hi johnathon and welcome to the forum.

    I think the reason that if you choose an item in one combobox that the others also show the same item is because they all are bound to the same field in the underlying table or query that is the recordsource for the form.

    (And I just tested and noticed that on an unbound form 2 comboboxes with the same recordset did not affect each other.)
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  4. #4
    Join Date
    Mar 2009
    Posts
    16
    Hi Nick and J,

    I am not highly experienced in databases but I did do a course around 9 years ago.

    I am making an appointment page. It has a date field, Time, Name field and comments field from 6:00am to 8:00 Pm every half hour. But I have three lots of this because three ppl can book in at the same time. The combobox name field gathers information from another table. I tried to make all the boxes unbound but then I could not create more records (New day). How can I create more records with an unbound field?

    thanks

  5. #5
    Join Date
    Mar 2009
    Posts
    16

    File example

    attached is an example file of what I have withoiut all the data
    Attached Files Attached Files

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Might be time to consider another training course

    Sounds to me like your design concept is wrong.

    If you completed this project, what would happen if another person joined the team... making it 4 people?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  7. #7
    Join Date
    Mar 2009
    Posts
    16

    more ppl

    I am very rusty, I have no memory of it at all. I am in telecommunications now

    There is only three ppl to be booked in at one time never 4
    It is all about booking in ppl for appointments on three different machines

    look at the attachment

    thanks.

  8. #8
    Join Date
    Mar 2009
    Posts
    16
    Quote Originally Posted by Bullschmidt
    Hi johnathon and welcome to the forum.

    I think the reason that if you choose an item in one combobox that the others also show the same item is because they all are bound to the same field in the underlying table or query that is the recordsource for the form.

    (And I just tested and noticed that on an unbound form 2 comboboxes with the same recordset did not affect each other.)

    Hi Nick and J,

    I am not highly experienced in databases but I did do a course around 9 years ago.

    I am making an appointment page. It has a date field, Time, Name field and comments field from 6:00am to 8:00 Pm every half hour. But I have three lots of this because three ppl can book in at the same time. The combobox name field gathers information from another table. I tried to make all the boxes unbound but then I could not create more records (New day). How can I create more records with an unbound field?

    thanks

    I have attched the file as well for more ideas.

    thanks
    Attached Files Attached Files

  9. #9
    Join Date
    May 2005
    Posts
    1,191
    To quickly answer your question (without looking at the entire .mdb), usually I use an Append Query after building it in VB.
    Me.Geek = True

  10. #10
    Join Date
    Nov 2009
    Posts
    6
    I am trying to write my unbound fieds on a form to a table. How do you build an append query as mentioned above?

    I've done things in access but have never gotten in this deep before.

    thanks

Posting Permissions

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