W
Wasim Yasin via AccessMonster.com
Dear All
I have fileds like Emp no, Name, Grade etc. in my Master table. I also have a
transaction table 'TADA' having the same fileds. The form is based on
transaction table 'TADA'. Now I used the dlookup function on 'Emp No' field
of form as following.
If IsNull(DLookup("[EmpNo]", "Combine", "[EmpNo]=forms![TADA]!EmpNo")) Then
MsgBox "Please Enter Correct Emp No."
EmpNo.Undo
Cancel = True
End If
I'm getting error on last two lines i.e.
EmpNo.Undo
Cancel = True
Second I want that when a n emp no matched with master table then the name,
grade and designation fileds of form populated with master table fileds of
name, grade and designation and control transfer to naxt field. Is it
possible or not? Please help.
Thanx.
I have fileds like Emp no, Name, Grade etc. in my Master table. I also have a
transaction table 'TADA' having the same fileds. The form is based on
transaction table 'TADA'. Now I used the dlookup function on 'Emp No' field
of form as following.
If IsNull(DLookup("[EmpNo]", "Combine", "[EmpNo]=forms![TADA]!EmpNo")) Then
MsgBox "Please Enter Correct Emp No."
EmpNo.Undo
Cancel = True
End If
I'm getting error on last two lines i.e.
EmpNo.Undo
Cancel = True
Second I want that when a n emp no matched with master table then the name,
grade and designation fileds of form populated with master table fileds of
name, grade and designation and control transfer to naxt field. Is it
possible or not? Please help.
Thanx.