Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 246
  • Last Modified:

access dynamic combo boxes

I have a sub report that I first want to select a position and the only show the courses under that position.  I have first setup a query that shows only the positions.  then in the courses I have a query that links the positions to the courses, in that query I have added this criteria [forms]![dbo_emp_course subform]![positionSelect]  but when I select the position I am getting a enter parameter value question.  What am I doing wrong>
0
sharris_glascol
Asked:
sharris_glascol
  • 3
  • 3
2 Solutions
 
PatHartmanCommented:
When you get prompted like this it is because Access can't resolve the reference.  Usually it is a typo but in your case, if I can believe your naming convention, the control you are referencing is on a subform.  To reference a subform, you must include the mainform in the name.
So -
 [forms]![yourmainform]![dbo_emp_course subform]![positionSelect]
or in some cases, you might need -
 [forms]![yourmainform].Form![dbo_emp_course subform]![positionSelect]
0
 
Rey Obrero (Capricorn1)Commented:
you are probably looking for cascading Combo box

and this one cascading combo demo
0
 
sharris_glascolAuthor Commented:
I have it so I don't get error message now but it won't let me select an option nor is it updating list
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
PatHartmanCommented:
I just posted a sample database a few minutes ago.  It includes cascading combos so it may help you.

http://www.experts-exchange.com/Database/MS_Access/Q_28551267.html#a40424709
0
 
sharris_glascolAuthor Commented:
Ok I got it to work...  BUT in my sub report it is updating a table so when I start with the first line and select my first combo position and then select my courses it filters correctly.  when I go to do an additional line and select a different position my course on the first line goes away.  is this because of the after update that I have on the positionselect_combo?
0
 
PatHartmanCommented:
OK.  Cascading combos in a continuous subform are a different problem.  I've attached yet another sample that explains the problem and offers a solution.  Keep in mind that this solution ONLY works for continuous view.  It will not work for DataSheet view since DS view doesn't allow controls to overlay one another.
FixCascadingCombos130128.zip
0
 
sharris_glascolAuthor Commented:
Thanks for all the help
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now