My Need:
I want to display a date in DB 2 on frmTokenDelivery in DB 1. Field in DB 2
is ProDate (i.e projected dated). Sorry for the long explaination. Any
assistance will be highly appreciated!
With regards,
I'm not sure I understand your problem exactly, but the following
example might give you some syntax clues:
I created the following query:
qryGetProDate:
SELECT * FROM [M:\Databases\DB2.mdb].tblImageBuild INNER JOIN
[M:\Databases\DB2.mdb].tblHardwareRequest ON tblImageBuild.HID =
tblHardwareRequest.HID ORDER BY tblImageBuild.HID,
tblHardwareRequest.DeliveryDate;
Then behind frmTokenDelivery:
Public Sub txtDeliveryDate_AfterUpdate()
txtProjectedDate.Value = DLookup("Max(tblHardwareRequest.ProDate)",
"qryGetProDate", "tblHardwareRequest.DeliveryDate = #" &
Me!txtDeliveryDate.Value & "#")
End Sub
I changed the value of the DeliveryDate textbox. The ProjectedDate
textbox filled in the value it found. Note that the code should not
have any line wrap. What I actually ran used First instead of Max so I
needed the ORDER BY in the query to ensure the order I wanted. I hope
this helps.
James A. Fortune
MPAP...@FortuneJames.com