Cant change the row source of a bounded combo box in Ms-access

[hrghauri]

I am trying to fill up the row source of a bounded combo box programmatically in Ms-Access. However, it does not show any of the numbers when I view the form.

Private Sub Form_Open(Cancel As Integer)
    Me.cmbErrorType.RowSourceType = "Value List"
    Me.cmbErrorType.RowSource = "1;2;3;4;5;6"
End Sub

When the form opens, I click on combo box, and it shows nothing in the drop down menu.
As far as I know, row source is used to build up the items in the combo box than why is this happening ?

[ItsMe]

It is probably the event that you are using. Instyead of OnOpen, try OnLoad or OnCurrent, depending on what you are trying to accomplish.

[hrghauri]

Nupe, that did not solve it. It turns out that it works fine when, in the table design, the look up field, is set to text box instead of combo box.

[ItsMe]

OK, you did mention that the combo is bound. If you are going to use a bound combo, why not use Rowsource Type = Table and store the values in a table?

The code you have will work in the proper event and in an unbound combo.

[hrghauri]

That's because there is an option button on my form. Depending on what the user chooses, the row source of the combo box should change dynamically i.e on the fly.

[ssanfu]

Nupe, that did not solve it. It turns out that it works fine when, in the table design, the look up field, is set to text box instead of combo box.

You have a look up field in the table?? You should never use look up FIELDs in a table. See http://access.mvps.org/access/lookupfields.htm

Using your example (changing names as necessary) from Post #1, I didn't have any trouble changing from a saved Row Source Type of "Table/Query" to a "Value List" on-the-fly.

You might try (on a copy of your dB) removing the look up field in the table and testing the combo box again.....

[ItsMe]

Using your example (changing names as necessary) from Post #1, I didn't have any trouble changing from a saved Row Source Type of "Table/Query" to a "Value List" on-the-fly.
.....

I was reading the problem as not being able to adjust the Rowsource. I think the major hurdle is the control is bound to a lookup field in the table and you would have to use DAO to adjust the table's properties or something. Whatever the solution is, insisting on a lookup property at the table level will cause lotsa work.