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.
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 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.