Using Row source of combo box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roy Goldhammer - 23 Mar 2005 13:09 GMT

Hello there

I have a continues form with combobox. If one of the fields is 1 the row
source should be "A"
and if the same field is 2 the row source should be "B"

Is there a way to do this?

Reply to this Message

Scott McDaniel - 23 Mar 2005 13:24 GMT

If you need to change this on a record-by-record basis, you can change the
.RowSource of your combo in the Form's Current event:

Sub Form_Current()
If YourField = "1" Then
YourCombo.RowSource = "SomeSQLString"
ElseIf YourField = "2" Then
YourCombo.RowSource = "SomeOtherSQLString"
End If
End Sub

As users navigate through the records on your continuous form, the
.rowsource will be changed ...

> Hello there
>
[quoted text clipped - 3 lines]
>
> Is there a way to do this?

Reply to this Message