Coba sintaxnya diperbaiki seperti ini:
VARA = DLookup("COIL_ OK", "T_PRODUCTION_ FIGURE", "TANGGAL=#"
& Forms!F_PRODUCTION_ MASTER!TANGGAL & "#")
Mohon dicek juga format textbox tanggal pada form. Harus menggunakan date
pula....
Mungkin ini bisa membantu...
--- On Wed, 7/4/10, Maulana <[email protected]> wrote:
From: Maulana <[email protected]>
Subject: [belajar-access] DATA TABEL
To: "access" <[email protected]>
Date: Wednesday, 7 April, 2010, 2:49 PM
Dear All
ada sintax sperti ini tapi kenapa y tidak bisa tampil pada
textbox yang di inginkan
ada textbox data diambil dari tabel
Private Sub TANGGAL_LostFocus( )
Dim VARA As Variant
VARA = DLookup("COIL_ OK", "T_PRODUCTION_ FIGURE", "TANGGAL=#" &
Forms!F_PRODUCTION_ MASTER!TANGGAL & "#")
GROSS_PRODUCTION_ PCS_TODAY = VARA
End Sub
Salam
MAulana
New Email names for you!
Get the Email name you've always wanted on the new @ymail and @rocketmail.
Hurry before someone else does!
http://mail.promotions.yahoo.com/newdomains/aa/
