Code to click a button that opens a new record in a form from another database

D

Don

I'd like to build an event that opens a new record in another
database's form when clicked. Any help out there?

Don
 
M

ManningFan

I'll help, but why on God's green Earth would you want to do something
as inefficient as this? You're opening yourself up to corruption and
file-locking nightmares, among other things.
 
D

Don

Well, perhaps it is inefficient. I have a database with a form that
asks if timber sales tasks are completed and records the answers (among
other things) in a table. One of the tasks is to enter a before and
after photo into a photo database that keeps track of the photo history
for forestry lots. If the user says "yes", that the photos have been
taken, I'd like to open a new record in the photo database so that they
can enter those photos.
 
M

ManningFan

Instead of going back and forth between databases, why not just link to
the photo database and open a form in the database you're in? Then the
data will appear in both places, without the overhead or confusion of
jumping between databases.
 
Top