Dlookup with TempVars

[anishkgt]

Hi All,

Was trying build security feature with Dlookup and tempvars. I've got a call log system where there is a check box if a followup is required. My idea is, if the [AttendedBy_FK] and the [Tempvars]![TempEmpID] are equal in then the Check box (chkFollowup) is enabled else it should be disabled.Thereby only the employee who logged the call can followup on it. So far my expression is as follows,

DLookUp("[LogID]",[tblLogOverview],"[AttendedBy_FK]='" & [TempVars]![EmpEmpID] & "'")

Unfortunately the above gives me a big error "The object doesn't contain the automation object 'tblLogOverview.' " I've attached a screeshot also.

Thanks in advance.

 

[vbaInet]

DLookUp("[LogID]", [B][COLOR="red"]"[/COLOR][/B][tblLogOverview][B][COLOR="Red"]"[/COLOR][/B], "[AttendedBy_FK]='" & [TempVars]![EmpEmpID] & "'")

 

[anishkgt]

Well that was the wrong expression, i was going after. i've managed amend the expression like this
If =DLookUp("[LogID]","tblLogOverview","[AttendedBy_FK]")=[TempVars]![TempEmpID] Then
Do something
Else Do something

I just can't get the dlookup to lookup the required data in the field. I've attached form, in which i need the Dlookup to lookup the LogID within this form from tblLogOverview and compare it with Attendedby_FK.

 

[anishkgt]

ok finally got it, expression is

=DLookUp("[AttendedBy_FK]","tblLogOverview","[LogID]=" & [Forms]![frmCallDetail-Log]![LogID])=[TempVars]![TempEmpID]

 

[vbaInet]

ok finally got it, expression is

=DLookUp("[AttendedBy_FK]","tblLogOverview","[LogID]=" & [Forms]![frmCallDetail-Log]![LogID])=[TempVars]![TempEmpID]

But you're not doing anything with this expression. It will only return True or False. Is that what you're after?

By the way you'll need to enclose the DLookup() part in Nz() to handle Null.
http://www.techonthenet.com/access/functions/advanced/nz.php

 

[anishkgt]

Yes ! just a true false, That expression is just part of my macro. I've added to the on load action of the form. It goes inside an if else statement. The expression will check if the AttendedBy_FK is equal to the TempEmpID. If equal the followup check box will be enabled and else not enabled. There will be no null values either. Thanks for the advise tho

 

[vbaInet]

Alrighty!