After approaching things many different ways we have settled into using an Alias RowSourceType for our ListBox controls. I will describe how we do this and I would like some ideas on how we might do this differently.

Here are the options we considered:

2. Alias
3. SQL Statement
4. Query (QPR)
5. Array

We create a remote view for each listbox and name them the same (or similar). We use the advanced options to have the view share an existing connection.

We add the view to the environment of the form. This makes it easier for our form designers to select the control source for the controls. Since we must share a connection we set the NoDataOnLoad to TRUE, and REQUERY() the views in the INIT method of the form.

We appreciate your time and consideration…

…tim