Dependent Combo Boxes

[swicklund]

I have two combo boxes in a form in which the second is dependent on the first (I have used a query with the criteria being:

[Forms]![PhoneLogfrm]![cboCategory]

I would like to use this same relationship in other forms, so I would like to have the criteria based on the current form, and not a specific form as I have shown above.

Any ideas??

 

[Crowley16]

are you trying to reference the controls in a saved query?

if so, then you can't, you'd either have to use parameters, or use dynamic sql...

--------------------
Procrastinate Now!