Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557

    Unanswered: Listbox to Table

    I have a listbox that I would like to store the values in a table by clicking a button. After it is added to the table I will requery the list box under the parts one to bring up a list of selected parts. See picture below.

    Does anyone have any ideas on how to do this. I have recieved several things on how to do this but I have gotten so confused that I need help .

    I really appreciate everyone that has been helping me in the past couple of days. I am sorry I have kinda disreguarded some things people have told me. I have so much going on. I have my normal daily duties and then this database plus I have side jobs going on. I am sorry for getting confused. I just need one good straight answer.

    Thanks,
    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

  2. #2
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    Here is the picture I refered to above.

    JS
    Attached Thumbnails Attached Thumbnails findformnew.jpg  
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Depends on the structure of your table...

    Simply enough, just add a record to the table and manually suck all the requisite information into it..

  4. #4
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    Originally posted by Teddy
    Depends on the structure of your table...

    Simply enough, just add a record to the table and manually suck all the requisite information into it..
    See adding a record to the table is what I dont know how to do :-/ I know how to suck the information to the list box.

    I will use the information to bring up a sales order form.

    What depends on the structure of my table?

    I am just trying to allow sales men the available option of using this search form to create a sales order. I dont know where to go from the point of showing the data they can select. Once they select it I dont know how to get that data where I want it

    I dont know what to do.

    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

  5. #5
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    I can't quite explain what I was getting at, so I'll try a different approach...

    How about if your lookup controls were in the header section for a continuous form that is bound to the table you wish to insert to. Then you may add a record and pull the values in accordingly using Me.NewRecord, and references to the approriate columns to manually populate the fields.

    Eg:
    Dim Index As Int

    Index = (YourList.ListIndex + 1)
    Me.NewRecord
    Me.(FieldName) = YourList.Column(approriate column, index)
    Me.(NextFieldName) = etc

Posting Permissions

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