combo form

G

Guest

Hi,
I'm trying to creat a link between two combo boxes in Access 2003.

cmb1 holds medical exams, whilst cmb2 holls items in a medical exam. I am
trying to get cmb1 to limit what appears in cmb2 based on the user's
selection.

E.g. If "Leg Exam" is slected in cmb1, how do you just get the Leg Exam
Items only in cmb2. I.e. Limit results, kind of like a filter?
Thanks - Nick
 
G

Guest

The row source for cmb2 has to include filtering based on the value selected
in cmb1. You will also need to requery cmb2 in the after update event of
cmb1.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to filter List Box based on multiple Combo Boxes 7
Newbie: problems with switching datasets 5
limit two combo boxes with unrelated data?? 4
Getting information from a table onto a form 1
Combo Box help 0
Filter form using multiple combo boxes selection 6
cascading combo box 20
Combo Box and Limit To List 4

Top