transfer a single record between 2 open databases

[antonyx]

http://www.londonheathrowcars.com/transfer.jpg

fairly straightforward picture.. you have a record in db1.. you view that record in a form.. click the transfer button.. and the record is transferred into db2..

i need something like this quite desperately.. if anyone has done this in the past.. or knows a good template/tutorial then please let me know..

once i know how to transfer a single field for a single record.. im sure ill be able to adapt it to my scenario..

thanks

 

[mic907]

i would like to see this done as well

 

[KeithG]

You could use an Append query to transfer the record. Then you would need to requery your form to show the record. I don't know how you could requery your form from a different db though. Can you link the table from DB1 to DB2 then just use DB2 instead of both of the databases?

 

[antonyx]

the actual scenario for when the record moves across is flexible.. whether one database is open.. or both.. or whether they are in the same folder.. or on the same network.. it doesnt matter..

all that matters is that the user can press a button.. (whether this is a transfer record.. or retreive record button) that will automate this process.. and allow the user to selectively move a chosen record from one database to another without any problems in between..

 

[KeithG]

Then I think an append query should do the trick.

 

[antonyx]

ok.. ill have a look at that soon and report back...