Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2007
    Posts
    17

    Unanswered: Help populating a combo box with numbers.

    Hi all

    I am trying to populate a combo box with numbers from 000 to 999 omitting numbers that already exist in a specific table.

    I am not sure i am asking the right way but is there a way to do this without creating a base table that contains 1000 rows with the sequential numbers?

    I am trying to end up with a combo box that allows the selection of any of the 3 digit numbers that are not already in use.

    Thanks
    J

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Look at "Demo000T999A2000.mdb".
    Look at Tables, Form2 (VBA), Query1MT, Module(GetNum).
    Open Form2, I think it is what you need.
    Attached Files Attached Files

  3. #3
    Join Date
    Jan 2007
    Posts
    17

    Awesome! Thanks a million

    I am a super noob and this little Access Files helps a lot.

    James

Posting Permissions

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