cascading comboboxes in a subform

[bigmac]

hello all, can you help please , In my sub form I have two combo boxes named [wps] and [process ], I want to be able to filter process based on the value in wps, if you can help me can you show me how in an sample database please?

 

[JHB]

It is a good description here + an example database.
http://www.fmsinc.com/MicrosoftAccess/Forms/combo-boxes/cascading.html

 

[bigmac]

thank you JHB for your response I will try this to see if it will work on a subform

 

[JHB]

Why shouldn't it?