H
highland
Hello
I have such code in access in Form called Formularz1:
Private Sub Form_Current()
Forms!Formularz1.Caption = Me![name]
[Etykieta17].Caption=DLookUp("[name]";"Table3";"[id]=20")
End Sub
and when i want to launch Form named: Formularz1
i receive error: "Syntax error"
When i change line:
[Etykieta17].Caption=DLookUp("[name]";"Table3";"[id]=20")
to:
[Etykieta17].Caption= Me![name]
everything works fine. The problem is in DLookUP().
I have Table "Table3" and field "name" in it, which is connected
by field id with Table1 which is the source for Formularz1.
There is record with id=20, i want to display it on Etykieta17 Label.
Why DLookUp does not work ?
Thanx
Michal
I have such code in access in Form called Formularz1:
Private Sub Form_Current()
Forms!Formularz1.Caption = Me![name]
[Etykieta17].Caption=DLookUp("[name]";"Table3";"[id]=20")
End Sub
and when i want to launch Form named: Formularz1
i receive error: "Syntax error"
When i change line:
[Etykieta17].Caption=DLookUp("[name]";"Table3";"[id]=20")
to:
[Etykieta17].Caption= Me![name]
everything works fine. The problem is in DLookUP().
I have Table "Table3" and field "name" in it, which is connected
by field id with Table1 which is the source for Formularz1.
There is record with id=20, i want to display it on Etykieta17 Label.
Why DLookUp does not work ?
Thanx
Michal