By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,277 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

Limiting options in one combo box based on the selected item in another combo box

P: 36
I read, and grokked the following thread:

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,
Jan 15 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 16,027
Looking at the thread you mentioned, this is an Access problem.

Post your problem in that forum unless a moderator moves this thread there first.
Jan 15 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.