make a macro to add default data in a new record


Mac Hardy

I have 2 simple tables (Birds and Numbers). When a field (Common Name) in
Birds is filled in with unique data I want the second table (Numbers) to find
its record containing the unique data (Common Name) and then write the data
from another field (Sequence) into the Sequence field in the first table.
Thanks for any help. Mac



Jeff Boyce


?You want Access to put the same data in two different tables? Why?

Access is a relational database. It is quite rare to actually need to
duplicate data like that.

If you'll describe the business need you are attempting to satisfy with this
approach, folks here may be able to offer alternatives...

More info, please...



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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question