K
KMac
I have several forms with combo boxes whose values are dependent on the value
of another combo box on the form. In the RowSource SQL statement of the
second combo box, I use the Forms collection to point to the first combo box
to supply the Criteria. (An example of the can be found on the microsoft
website
http://office.microsoft.com/en-us/assistance/HA011730581033.aspx
I have been using this technique since Access 2.0 and it has always worked...
until Access 2003.
With Access 2003, when I click the second combo box, it brings up a prompt
to Enter (as in the above example would be [Forms]![Combo Form]![Category]
?
Would someone try this and confirm that their Access 2003 is behaving the
same as mine or NOT?
of another combo box on the form. In the RowSource SQL statement of the
second combo box, I use the Forms collection to point to the first combo box
to supply the Criteria. (An example of the can be found on the microsoft
website
http://office.microsoft.com/en-us/assistance/HA011730581033.aspx
I have been using this technique since Access 2.0 and it has always worked...
until Access 2003.
With Access 2003, when I click the second combo box, it brings up a prompt
to Enter (as in the above example would be
[Forms]![Combo Form]![Category]?
Would someone try this and confirm that their Access 2003 is behaving the
same as mine or NOT?