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

  • Thread starter Thread starter Don
  • Start date Start date
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
 
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.
 
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.
 
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.
 
Back
Top