Add new record

[Osix]

Hello all!

I am novice in access and i have problem:
I have main form with many subforms and button "add record".
On button click records adds from main form and all subforms (if those are filled) but i want that records adds from main form and only one subform.
I try out different ways to code it but nothing works that I want.

Are someone have idea how to solve it?

 

[Galaxiom]

Subforms that have the Master Link Fields and Child Link Fields properties set will behave as you have described. If you remove these entries the subforms will not get new records but neither will they automatically follow the record in the main form.

Maybe you could describe what you are trying to do and why you have all those subforms and we might have other suggestions.

 

[Osix]

In main form I have Combo Box with values Printer, Monitor, Notebook, ... , Other.
In start all subrorms are unvisible.
If choose Monitor from Combo Box, then subform Monitors is visible.
If choose Printer from Combo Box, then subform Printer is visible.
...
All works if user fill only one subform, but if user fill more subforms(in star choose monitor fill all fields and then think over and choose printer) then all filled subform fields are added, but this shold be dispose, because user see only one subform and think that this is a only information that will be added.

 

[Osix]

In main form I have Combo Box with values Printer, Monitor, Notebook, ... , Other.
In start all subrorms are unvisible.
If choose Monitor from Combo Box, then subform Monitors is visible.
If choose Printer from Combo Box, then subform Printer is visible.
...
All works if user fill only one subform, but if user fill more subforms(in star choose monitor fill all fields and then think over and choose printer) then all filled subform fields are added, but this shold be dispose, because user see only one subform and think that this is a only information that will be added.

 

[Galaxiom]

What is the relationship between the Printers, Monitors, Notebook and Other subform records and the records on the Main form?

 

[Osix]

Relationship Type: One To One