Results 1 to 13 of 13
  1. #1
    thewabit is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    36

    list box items

    I am trying to populate a form with table data that is linked to a selected
    item presented in a list box. Each of the items in the list box have data
    stored in a table. I am looking for maybe some VB that when that item is
    highlighted and a button at the bottom is pushed, it opens another form and
    the table data is displayed. To complicate things, the form I want to open up
    has 2 subforms that also need data from the table with sub tables.



    PLEASE help!

    Thanks!

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It would probably help if you can post your zipped up db for us to play with.

  3. #3
    thewabit is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    36
    It says "invalid file" when I try to upload it.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Are you trying to upload a .zip file and is it < 2 MB in size?

  5. #5
    thewabit is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    36
    here it is...It worked that time.

    I tried to zip it in rar...and it made it about 2mb.

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    One of the tricks is to make a .rar and then rename it .zip so it will upload. You need to make sure and tell everyone it is really a rar file with the wrong name so they will rename it after download.

  7. #7
    thewabit is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    36
    The tables are: tblIEP_template and tblIEP_question

    The forms are: tblIEP_template..when you make a selection from the listbox, hit "edit" at the bottom. That will take you to frmIEP_question.

  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Do you have this password protected? Did you Compact and Repair before trying to zip it?

  9. #9
    thewabit is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    36
    oopss...sorry.

    I sent it to you PM.

    I did not compact and repair i don't think.

    Do I need to?

  10. #10
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Got it. I cut the file almost in half when I did a C&R.

  11. #11
    thewabit is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    36
    See...I learned me something.

    I sure hope you can figure this one out...It has made me crazy. I'm learning...it's just slow.

    Thanks for your time!

  12. #12
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Would you feel better if we took this off line to resolve for now since most will not be able to follow what we are doing anyway?

  13. #13
    thewabit is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    36
    If you don't mind...that would be awesome!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 10-28-2009, 12:44 PM
  2. Multiple detail items per line
    By needafix in forum Reports
    Replies: 3
    Last Post: 10-22-2009, 11:04 AM
  3. Generate a List of Items from "Many" Relationship
    By Hammer Mark in forum Reports
    Replies: 0
    Last Post: 04-20-2009, 07:30 AM
  4. Replies: 1
    Last Post: 11-11-2006, 08:23 PM
  5. Added items in a column.
    By Wrangler in forum Forms
    Replies: 3
    Last Post: 03-25-2006, 07:56 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums