Multiple forms to add a record to the table

[AmaroNeto]

Hello!
I want to add a record to the table through multiple forms, so I built 3 forms, each one with different fields of the table, then I built another form and put the others inside it in a 3 page tab. At that fourth form I put an Add button but when I click it, 3 records are added to the table, each record only with the fields of those respective forms.


How do I add a single record with the fields of the forms filled.
Thank you for the attention, and sorry for my bad english, I hope you understand.
Amaro Neto

[pbaldy]

Why multiple forms? Because of the number of fields (if so, raises a normalization question)? From the sound of it, I'd have a single form with a tab control to organize the fields logically. I would only have separate forms if there were related tables involved.

[ssanfu]

I agree with Paul. Just use a tab control to arrange/group the controls.

What does the Save button do? Any code behind it? The data will be saved if you close the form, move to a different record, do a requery.

[pbaldy]

Uh... Paul, shouldn't that be "Tab" control?

Yes, stupid autocorrect or stupid Paul, not sure which.

Editing to fix.

[ssanfu]

Has to be the confuser's fault

Happens to me a lot. It does what I tell it to do, not what I want it to do!!

[AmaroNeto]

Hum, Thank you for the replies guys.
I'm just a beginner, I'll try the Tab control.
Thanks again.
Amaro Neto

[pbaldy]

No problem, and welcome to the site by the way!