How can I make a Central Form with both select and update?

[Björn]

How can I design a central form with both selectfunction for certain tables and updatefunction for others?
I have a many to manytable with foreign keys to connect several tables.

 

[Galaxiom]

Subforms possibly. You can remove all the extraneous stuff like record selectors and the border from the subforms and their controls will even look like they are part of the main form. Use events in the form or subforms to trigger procedures in the other subforms.

The ultimate "do anything" form can be achieved with unbound controls.

The data is loaded into the controls using Domain Lookups to tables or queries. These actions can be triggered from the On Current event of a subform for example.

Changes are saved using commands run from events. You can have a save button or trigger from the On Current event of the record selection subform for example.

 

[Björn]

Thank you very much for your help!!
I´ve been on vacation for some days so I haven´t been looking at the Forum during that time. I´m not very used to access but I want to learn much more about it because I have sampled lots of data from lakes which I want to write into an Access-database. I´ve done some progress but the database isn´t very good yet. I want to make forms for reading and inputs.
I´ve read some negative opinions about using LookUppwrds. Some call it even evil. How to do instead?
Since your answer I have now learned a little more about events, controls and buttons as you told me.
I hope for further progress.

 

[Galaxiom]

Lookups in tables are not recommended. Yes some consider them evil.
However the DLookUp function is a different matter. It is vitally important in complex form desgin.