I have a question about listboxes and rows in Access tables. I'd like to list data in a specific row of my table in a listbox on a form. I'm basically looking for the same type of result as the "Field List" option in the listbox properties, I just want the list to be values in a row instead of the column names. I'd appreciate some guidance on how this may be accomplished.

Once you've retrieved the row you want from the recordset
using ADO or DAO with a connection/database object, you
can build a string dynamically, something like this:

Dim strValueString As String


strValueString = rst!Name & ";" rst!SSN & ";" rst!Phone
Me.cboComboBox.RowSource = strValueString

Be sure to keep "ValueList" for the RowSourceType

Hope that helps!

Warren