Solved Wrong information appearing in some records

[atrium]

I have a project where I have Clients that have one to many Matters. When I update a Matter belonging to a client all seems OK and when I go onto the next Matter connected to another Client the second Clients name is now the same as the previous clients.

Am I failing to clear out some variables or do I have the Client File in edit mode so when the new record is opened the retained info from the previous Client is moved in and updates the source of the second clients record.

Any suggestions.

Would appreciate any help

Atrium

 

[CJ_London]

sounds like you are using a combobox to find the next client and the combobox is bound or perhaps you are using a subform that does not have the linkchild/master fields set. Could be any one of a number of things, but not much point speculating without knowing more. Please describe your setup for forms and how you move from one record to another

 

[atrium]

The user can get to the Matter via 2 ways
1. Open the Parent (The Client) and select one of the related Matters that are listed in a tabbed subform on the Client form. The Client Form remains open and the Matter form appears on top.

2. Or they can search for the Matter directly to display the relative Matter Form.

Linked to the Matter are Action Tasks which are jobs that need to be actioned when due. The tasks use precedent templates that merge info from a merge file that is produced using the relative Client and the Matter records.

The Merge process uses VBA to automate MSWORD.

That all works as planned but only every now and again the Client Name of the last client used appears as the Client Name in the client being used right now. The current Client's record has been updated with this new name. It is only the client name that is effected.

Thank you for your interest CJ

 

[CJ_London]

what is your table structure and relationships? - names will not 'cross over' on a whim. Are you using autonumber primary/family keys?

And on your forms - do you ensure the 'old' client data is cleared from the form before populating with 'new' client data.

 

[The_Doc_Man]

If the form with clients and matters isn't set up as a Main/Sub form with a parent/child relationship between the Main form and Sub form on the Parent ID, but instead uses some type of unbound search, your problem may be in failing to properly reset the selection boxes.

 

[atrium]

Thanks for you input guys.

I found the problem. I was changing the contents of a bound field which happen to be the client name. changed my field to an unbound field and all processing is perfect.

Tested it about 20 different ways with mulitiple and different clients without errors. I actually stepped through the code line by line until I found when it changed.

I really appreciate your input

Love this site

Atrium