Parameter Problem

[Richie2837]

I have been using a parameter query which was looking for contact types (from a lookup) in my main table. I've since changed the contact types to a separate table, which has caused the parameter query to stop working, and no matter what i try I cannot get it going again. What do I need to do?

 

[ajetrumpet]

Of course it doesn't work Richie, because your parameter probably says something like this...

WHERE oldtable.oldfield = "whateverYouTypeIntoTheParameterBox"

and thus, when you type the parameter into the box, it is searching your old table.

Does this sound about right??