G
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
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