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]

Mac

?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...

--

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.