I read, and grokked the following thread:
http://www.thescripts.com/forum/thread577386.html
and it worked for me initially.
However, I tried using it on a an AutoForm generated form, which contains a subform, and it no longer works! I'm not sure what's going on - it is complaining about not being able to find the subordinate control from the master combo box's event script.
When I try to enter the second (i.e. dynamic) combo-box, I now get prompted for a parameter to the query. It seems that the query is unable to access the controlling widget with the Form!DbaseName!Control syntax.
Do subforms change the structure of the object tree?
Also, there a way to access the current record (i.e. at the cursor) in another database from within the query criteria? Could I use something like Table!DbaseName!Field_name ?
thanks in advance,
-cybervegan