synchronize my 2 combo boxes

R

Revned

Hi everyone,

I have a subform frmMasterList in my Form: Review Details
I have 2 combo boxes with

In my frmMasterList i have this field
PO Trigram DTBTyp Date Equipment

on my first combo cmbPONo i have this
row source: SELECT DISTINCT PO FROM qryMasterList UNION SELECT' All PO' FROM
qryMasterList GROUP By PO;

on my 2nd combo cmbEquipment i have this
control Souce:qryMasterList.Form!Equipment

I want that when I select from my cmbPONo
it will limit my second combo with those PO has 2 kinds of Equipment
Can any help me how to figure out, or can anyone is kind to help me how
should
my VBA looks like?


Thank you very much in advance, I appreciate..
 

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

my combo boxes 2
Creating a Search using a combo box and then creating a report. 4
OpenForm Problem - populating Opened form 4
EXCEL MERGE AND LINK ISSUE 2
Combo box 0
Need help cascading 5 combo boxes 12
use multiple combo boxes to filter table, results displayed in sub 17
combo box goes blank? 6

Top