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.
"crimsonisland" wrote:
[Quoted Text] > 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.
|