dlookup

[gtsek]

Hi . I have 2 tables , mobile number is the relation shipped data one to many.
first table has client data name, surname etc
second table has mobile number and visit details
i have a form for 2nd table and i put 2 labels . I need when i put the mobile number (afterupdate vba) first label caption be the name from first table and
second label caption be the surname for first table also.
i have in module 3 variables 1 integer for mob number and 2 string for name - surname
Private Sub kinito_AfterUpdate()
i = kinito.Value
n = DLookup("(onoma)", "pelates", "(kinito)=i")


Lname.Caption = n
Lsurname.Caption = s
End Sub


EDIT:
i try to say that :
variable n is from table pelates field onoma when field kinito=1

 

[xenou]

Hi, try:

n = DLookup("[onoma]", "pelates", "[kinito]=" & i)

 

[gtsek]

Hi, try:

n = DLookup("[onoma]", "pelates", "[kinito]=" & i)

thanks
i do it like this
n = DLookup("[onoma]", "[pelates]", "[kinito] =" & Forms("episkepseis")("[kinito]"))
and works... your is simple. i will try