Keeping on the same record while changing forms

[TomBrierley]

While going through forms, I want to stay on the same record through out while filling them in. Is there any way of doing this, or will i have to click the customer every time to change the record?

[ItsMe]

What technique are you using when you are "going through forms"? If you Navigate to a different record, you are at a different record and the controls on your form will represent the respective record.

[TomBrierley]

The technique I've used is just a macro on the button to go to a different form.

[orange]

It would be helpful to know what your underlying table structure is and how the tables are related.
Based on what you have shown, I would advise against spaces in field names if that's how they are defined in the table(s).
Client1 and Client2 would generally indicate 2 separate records. But we don't know your tables structure, nor the purpose of the proposed database.

Good luck with your project.

[ItsMe]

The technique I've used is just a macro on the button to go to a different form.

Moving focus from one Form to another Form should not cause a form to Navigate to a different record. Is a form navigating to a different record in an unpredictable fashion?

[Missinglinq]

This would appear to involve a family, or possibly a former family, unit, given the completely separate sets of contact information for Client1 and Client2, and data for a number of children.The OP apparently wants to move from one Form to the related Record on one or more other Forms...but what he needs, I think, is a

Family Unit Table (for data on each 'unit' as a whole)
Parent Table (for individual parent's data)
Offspring Table (for individual data on each child)

The Family Unit Table would be the basis for a Main Form, while the Parent Table and the Offspring Table would, in turn, be the basis for Forms to be used as Subforms to the Main Form. This construct would, of course, eliminate the need for doing anything to remain on the 'same Record," as that would be done automatically, by the Main Form/Subforms configuration.

Linq ;0)>