Error 7773: ...can't set the LimitToList property to No right now

[GeorgeMar]

I ahave a List Box that depending on the selection will change the RowSource
of a Combo box on a form.

The Combo box sometimes has a query and sometimes is blank.

In the VBA when there is a query I have
me!ComboBox1.RowSource="SELECT ..."
me!ComboBox1.LimitToList=True

That works fine

Otherwise
me!ComboBox1.RowSource=""
me!ComboBox1.LimitToList=False

I get: Error 7773: ...can't set the LimitToList property to No right now.

Any ideas

Many thanks in advance!
George

 

[GeorgeMar]

I've worked out the problem. I am posting this reply for others who may come
across this error.

The error "can't set the LimitToList . . ." occurs because it wants the
Bound Column to be number 1 when the control is set to False.

In my case there was a condition that set the .BoundColumn=2 and when
..LimitToList=False, it stopped with the error. By changing the
..BoundColumn=1 it worked OK.

regards
George

 

[Jon Stubberfield]

Also had same problem. I think the bound column refers to the column number of the field in the table which MAccess is using to get the data from. e.g. if the table you want Maccess to use for the list box has columns ID, Date of Birth, gender then ID would be column 1, DOB column 2 etc. The bound column number should match up with the number of the column that contains the data you wish to store in the new table on your access form.This should then allow you to use the LimitToList "no" option.