Pass Rowsource from Module to Form Listbox 1

[dusterb]

I'm trying to create a Search Results list which will be displayed in a listbox (Results) on a popup form (ArticleSearchResultsForm). The Search form (ArticleSearchForm) uses a function to build an SQL string that I'd like to pass as the rowsource for the listbox field. Here's what I have:

Form.ArticleSearchResultsForm.Results.RowSource = varSQL
DoCmd.OpenForm "ArticleSearchResultsForm"

It's not working. Any hints?

 

[jebry]

Hi!

Try this:

DoCmd.OpenForm "ArticleSearchResultsForm", , , , , , varSQL

Then in the load event of the form use

Me!Results.RowSource = Me.OpenArgs

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[dusterb]

Thanks jebry, that works perfectly. Problem solved in under 5 minutes!