Friday, August 21, 2015

Specifying Textual Criteria That Comes from a Field on a Form:




=DLookUp("[EMAIL]","penyelia","[NAMA PEGAWAI] = '" & [Forms]![borang]![NAMA PENYELIA] & "'")

Email – specific field
Penyelia – table
Nama penyelia – field yg berkaitan
Forms – berdasarkn borang
Borang – form name
Nama penyelia – field ygdiisi


=[nmPenyelia] & IIf(Nz([penyelia.EMAIL])<>""," [" & [penyelia.EMAIL] & "]")
on

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)