Best practice question: Unbound form to update multiple tables

E

Epoh Rio

Can I create a single tabbed form that will update multiple tables?

I want to be able to enter information on a tabbed form, first tab will
create a basic record and the other tabs will be related to that basic record
by adding additional detail.
 
A

Allen Browne

Yes, you can do that if you feel like writing code to handle each step of
the process, instead of just taking advantage of the built-in functionality
of bound forms.

You could also use machine code to write processer instructions directly
without using Access. Depends whether you have a reason to do that, or if
you might have other things to do with your life.
 
E

epoh97

Allen Browne wrote:

You could also use machine code to write processer instructions directly
without using Access. Depends whether you have a reason to do that, or if
you might have other things to do with your life.

-----> No thanks.

"Yes, you can do that if you feel like writing code to handle each step of
the process"

---->I dont mind writing code if you can point me in the right direction.

"instead of just taking advantage of the built-in functionality of bound
forms."
----> Is it possible to update multiple tables with one bound form?

Thanks
 
A

Allen Browne

It might help to understand why you are doing this.

You say you have a tabbed form where the first tab creates the basic record,
and subsequent tabs handle the data that is related to the basic record.
That's essentially what forms and subforms are for. The form itself is bound
to the main table. Each subsequent page of the tab control can hold a
subform bound to a related table. All done.
 
E

epoh97

Good point

Allen said:
It might help to understand why you are doing this.

You say you have a tabbed form where the first tab creates the basic record,
and subsequent tabs handle the data that is related to the basic record.
That's essentially what forms and subforms are for. The form itself is bound
to the main table. Each subsequent page of the tab control can hold a
subform bound to a related table. All done.
"Yes, you can do that if you feel like writing code to handle each step of
the process"
Click to expand...
[quoted text clipped - 4 lines]
forms."
----> Is it possible to update multiple tables with one bound form?
Click to expand...
Click to expand...
 
Top