Hi All.

I have just finished working on a insurance agency policyholder/ policy management. 
Every things works fine on my pc.  I installed the application on the end users pc and everything goes crazy

The forms use subforms main form is Policy Holder, subform has basic policy information, Clicking on the Policy Number in the subform opens the Policy form with all information on the policy.  My PC work correctly.
On end user PC the click of policy number of subform may bring up the correct policy, I may bring up one of the policies for the Policy Holder or it might bring up a policy form the first person in the file.  It has started at the first policy for that person and just worked its way through the list for that person, doesn't mater which policy you click on .

Has anyone had this kind of thing happen.

I'm suspecting bad memory in clients PC.

Foye.
Wilder's Software

found the problem.

Needed to add a xresultsetclose after record retrieved.

would be nice if preview functioned the same as live db.