-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Use the Form's AfterUpdate event to run an INSERT command into the table
in DB II. E.g.:
Private Sub Form_AfterUpdate()
' The path to DB II
Const PATH = "C:\My Documents\DB_II.mdb"
Dim db As DAO.Database
Set db = CurrentDb
db.Execute "INSERT INTO RequestInfomation IN "" & PATH & "" (" & _
(RequestIDNumber,SubmitersEmailAddress,DateReceive d," & _
Approver,DateProcessed) " & _
VALUES (" & Me!Tracking# & ",'" & _
Me!Requestedby & "',#" & _
Me!DateRecvd & "#,'" & _
Me!Approvedby & "',#" & _
Me!DateComplted & "#)", dbFailOnError
End Sub
Add error handling.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQ868LYechKqOuFEgEQKpdQCgtFfFBOwI5bCrpTDjmzI3++ sjRL8An02j
OmpEDKFpMm42DkmbUo3s+hYC
=3Pzh
-----END PGP SIGNATURE-----
dr******@gmail.com wrote:
It would be great if someone could help me solve this.
Here is my situation..
I have have 2 databases containing these the following two,
subsequently.
Database I
TABLE: Requests:
- *Tracking#
- Requestedby
- DateRecvd
- Approvedby
- DateComplted
Database II
TABLE: RequestInfomation:
- *RequestIDNumber
- SubmittersEmailAddress
- DateReceived
- Approver
- DateProcessed
The "Requests" Table of DATABASE I is the main table accessed via form.
However, when I use Database II, I would like the RequestIDNumber,
SubmittersEmailAddress, DateRecieved, Approver, and DateProcessed to be
populated from the Requests Table, and update accordingly.
Tracking# = RequestIDNumber
Requestedb = SubmittersEmailAddress
DateRecvd = DateReceived
Approvedby = Approver
DateComplted = DateProcessed
Can this be done?