How do I populate a listbox from SQL

[Guest_imported]

My company's VBA expert left the company and all her Macros have been given to me (the Web Programmer/Developer who has NO knowledge of VBA). We have a Fax macro that I need to add a listbox in the dialogue box that displays all the project codes (these are pulled from SQL). If this is a silly question, I apologise, VBA is greek to me!

 

[bondm007]

I populate a listbox by setting it's RowSource property to the select statement.

Eg:

Me!lstBox.RowSource = "SELECT [Field1], [Field2] FROM

WHERE [Field1] = 'Nothing'"
Me!lstBox.Requery

*Insert this line into the VBA Code. If the listbox is on the current form. Make sure your listbox has the Columns property set to the same number of fields in your select statement and that the table exists in your database. Hope this helps.

 

[WebGirlForced2DoVBA]

This is great! Thank you sooooooooooooo much!