Cascading Combo Box Question

[Coldsteel]

I have a problem. I built a simple Cascading Combo Box, which is not picking up my forms statement correctly. Can anyone see what I am doing wrong? Here is my Row Source code for the Combo Box:

SELECT DISTINCTROW Table1.zip FROM Table1 WHERE (((Table1.city) Like forms!FRM_REFERRAL_EDIT!combo0));

 

[Guus2005]

If you're using LIKE, add an asterisk at the beginning or end. Using LIKE means the you're not looking for an exact match. You can use = instead if you do.

I don't know what's cascading is got to do with anything.

HTH