I have a combo box on a form which is bound to a table. The "row source type" is a value list and I have typed in the values for "row source".
A "default value" is also set.
I have a need to occasionally change the "default value". The new value can be selected from another table. ie not the control source of the current form. This would seem simple enough but I can not get it to work. I have used syntax like:
=[tblParameters]![variable]
=[tblParameters].[variable]
but nothing seems to work. Can anyone help me with the syntax?
A "default value" is also set.
I have a need to occasionally change the "default value". The new value can be selected from another table. ie not the control source of the current form. This would seem simple enough but I can not get it to work. I have used syntax like:
=[tblParameters]![variable]
=[tblParameters].[variable]
but nothing seems to work. Can anyone help me with the syntax?