How do I set combobox data source to a dynamic SQL statement?

I have a combobox on a form.

Coming from VB, I like to build a dynamic SQL statement and then set
the control's data source to the SQL statement.

Please tell me how to do that in access using the VB editor.

I have the dynamic SQL statement working fine, I just need to set the
control's source programatically.

Thanks in advance.

Newbie wrote:

Quote:

I have a combobox on a form.
>
Coming from VB, I like to build a dynamic SQL statement and then set
the control's data source to the SQL statement.
>
Please tell me how to do that in access using the VB editor.
>
I have the dynamic SQL statement working fine, I just need to set the
control's source programatically.
>
Thanks in advance.

If by "data source" you mean the rows displayed in the drop down list then
that is actually the RowSource property of the ComboBox. All you need is...

Me.ComboBoxName.Rowsource = "Your SQL"

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

On Wed, 11 Oct 2006 17:57:16 GMT, "Rick Brandt"
<rickbrandt2@hotmail.comwrote:

Quote:

>Newbie wrote:

Quote:

>I have a combobox on a form.
>>
>Coming from VB, I like to build a dynamic SQL statement and then set
>the control's data source to the SQL statement.
>>
>Please tell me how to do that in access using the VB editor.
>>
>I have the dynamic SQL statement working fine, I just need to set the
>control's source programatically.
>>
>Thanks in advance.

>
>If by "data source" you mean the rows displayed in the drop down list then
>that is actually the RowSource property of the ComboBox. All you need is...
>
>Me.ComboBoxName.Rowsource = "Your SQL"

Thanks.

How do I set combobox data source to a dynamic SQL statement?

re: How do I set combobox data source to a dynamic SQL statement?

re: How do I set combobox data source to a dynamic SQL statement?

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about