add record to listbox?

[jerry28ph]

Hi All,

How can I add record(s) to listbox from combo box? Is it possible in Access? Please guys need your help.

Thanks and more power.

Regards,
Jerry

 

[boblarson]

One thing you DO NEED to do is to stop reposting the same question again and again. I've noticed that you keep doing that - posting as one topic and then posting again as a different topic. This continued action will get you banned from the forum. Do NOT keep doing it.

 

[jerry28ph]

double posting.

Hi boblarson,

sorry for that, if i dont get the answer from my previous postings, im sure they didnt get my question if my queries are too long or confusing. I re-posted the same topic and re-phrase it. Now i know it might cause me banned from forum, please dont let me get banned from this forum because it helps me a lot as a beginner. Ok from now on, i will post my question as clear as possible and i will avoid double posting.
Thank you so much for reminding me.

Best regards,
Jerry

One thing you DO NEED to do is to stop reposting the same question again and again. I've noticed that you keep doing that - posting as one topic and then posting again as a different topic. This continued action will get you banned from the forum. Do NOT keep doing it.

 

[Banana]

It is certainly possible.

I would think by far the most simplest thing to do for a listbox bound to a table or query is to use a Recordset object...

Dim rs As DAO.Recordset

Set rs = Me.MyListBox.Recodset

With rs
   .Addnew
   .Fields("NameOfColumn") = <Value>
   'Repeat as necessary for each column, if more than one
   .Update
End With

If you're using a Value List then it's even easier-

Me.MyListBox = Me.ListBox.RowSource & "; <NewValue> "

HTH.