Dynamic Search Forms Not Working after redefining primary keys

[samjh]

Hi,

I have used the dynamic search forms to do all my searches.
They were working absolutely fine, however in a couple of my tables, I have deleted the autonumber primary Key and made one of the other fields the primary key (as the other fields were unique anyway).

I have fed all the information through every form, and query to ensure that I am picking up the correct data. However on my Client Search form, when I double click it should take me to the client form, but it comes up with an error in the Do.cmd Open Form, I donlt know what the ewrror is, as it hasn't changed, just the linkcriteria, which I have redefined, and if I hover over it, it shows what the new number is.

And in my Cost centre search form, when I double click on the cost centre it asks me to Enter Parameter Value, but in the parameter value box, it has above the box for me to type in, what the cost centre was that I double clicked on.

Does anyone have any idead what I have done or need to do to fix this.

Also in both these cases, the primary keys were autonumbers they are now Text, not sure if this makes a difference or not.

thanks.

 

[pbaldy]

Makes a big difference:

http://www.baldyweb.com/wherecondition.htm

 

[samjh]

Thank you so much. My form works again...thank god.

 

[pbaldy]

Happy to help!