how do i get records to append to multiple tables

[Deenos]

I have 4 option buttons but when one is selected I would like the information
in several fields to append to multiple tables and appear in the main form. I
want this to happen automatically. I am new to Access Programming so any help
is appreciated, but please be very clear since programming jargon is not at
my finger tips.

Thank you,

 

[Jeff Boyce]

Deenos

It strikes me a bit unusual to have one form updating multiple tables. If
you'll provide a bit more specific description of your tables and your form,
folks here may be able to offer more specific suggestions.

Folks here are happy to help, but first we need a better understanding of
"what" ... and you've described "how" (how you are trying to solve some
issue ... ?!what issue?!)

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Keith Wilby]

I have 4 option buttons but when one is selected I would like the
information
in several fields to append to multiple tables and appear in the main
form. I
want this to happen automatically. I am new to Access Programming so any
help
is appreciated, but please be very clear since programming jargon is not
at
my finger tips.

If you're storing any element of data more than once then your table design
is not normalized. Either Google for normalization or have a look in the
help for it, but doing what you've asked about is a huge no-no and if you do
it then it will eventually bite you hard.

Regards,
Keith.
www.keithwilby.co.uk