synchronize my 2 combo boxes

  • Follow


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..


0
Reply Utf 3/13/2010 6:48:01 AM


0 Replies
444 Views

(page loaded in 0.018 seconds)

Similiar Articles:
















7/24/2012 3:59:07 PM


Reply: