Seems like a good application for replication.
the record info to also update/create in another db. So I need some code
that will check to see if the record exists in the other db, if not, create
a record, and then populate those fields that are shared between the two
databases (so that I only have to enter data in the main db). Make sense?
I'm thinking I need to use some Automation function or Shell??? But I'm new
to VBA so I don't know where to begin and can't find any code that seems to
do what I need. Thanks!!!