Adding form values into a list box

[shabbaranks]

Hi all,

I was wondering if someone could help me? Im trying to collate values from within a form and add them to a list box. Would I use sql and would I declare all of the form controls and then use a mysql insert command or is there a better way?

The reason I am inserting them into a list box is because the list box will grow as more entries are made and then the user would submit all the values to the table at the end.

 

[mdlueck]

within a form and add them to a list box.

I think I understand what you are trying to do other than that little bit. Could you clarify that, then I will reply when I better understand your question.

 

[shabbaranks]

Thanks for your time with this.. Ok so I have my form which consists of combo and text boxes, the user makes thier selection from the form and then (this is where I am stuck) clicks a button which adds the forms combo boxes and text boxes values (control values??) to the list box.

 

[mdlueck]

then (this is where I am stuck) clicks a button which adds the forms combo boxes and text boxes values (control values??) to the list box.

What "list box" might you be referring to? A list box on the same form? Or do you mean INSERT a record to the table and have that new record show up in a Multiple Records list on a different form?

 

[shabbaranks]

As per this example I am trying to get value 1, 2 and 3 into the list box using a button. Once submitted to the listbox potentially I would then add more values into value 1, 2 and 3.

http://imageshack.us/f/207/38906208.jpg/

 

[mdlueck]

As per this example I am trying to get value 1, 2 and 3 into the list box using a button.

List boxes look like they use a DAO.Recordset as Comboboxes do. Search the Access VBA help for "List Box" and the "How to: Add "(All)" to a Combo Box or List Box" entry has some sample code for you.