List Box Column Data

[crimsonisland]

I have a list box that is being used to display search results. The list
box's Row Source Type is Value List and it has 5 columns. I have a search
button that calls a function that generates a SQL statement based on the
completed fields. The results are returned in a RecordSet. I want to add
each record (which is made up of five fields) to the list box, but making
sure that each field in the recordset is assigned to a column in the list box.

This may be confusing, so let me know if you need clarification.

Thank You,
Brian.

 

[crimsonisland]

Sorry, I am an idiot. I figured out to change the Row Source Type to
Table/Query and assign the SQL state that I generated in the function to the
Row Source. I apologize for the post.

Thank you,

Brian.