The statemewnt give the same result

[Lou_Reed]

In the small db file that I have attached it seems that in the form that opens frmHelpDeskTickets the VBA code behind the - send ticket - command is rather vague. This code works completely, but it is hard to understand the difference between the use of stWho and stWhere.

They produce the same thing, the the same value, so what is the difference?



Any help appreciated. Thanks in advance.

Respectfully,


Lou Reed

Okay, I looked at it again and it does seems that stWho and stWhere have one slight difference. The stWhere does indicate a the tblUsers, which is where the name comes from. I just do not see how that can make a difference. Please explain.

[jwhite]

I see that this is an example database from DatabaseDev.

1. stWho is assigned the value of the "Assigned To" selected (Me.cboAssignee)
2. stWhere is assigned with the table field to compare to and the value of stWho
3. varTo is assigned the value of the DLookUp() function based on the value of stWhere.

All of that could have been accomplished in one simple line and adding Nz in case it wasn't found:

varTo = Nz(DLookup("[strEMail]","tblUsers","strUserID = '" & Me.cboAssignee & "'"),"")

Did you change the table fields to have "str" at the beginning? The prefix is meant for code variables, not field names.

[Lou_Reed]

No not yet, I have not changed the variables from st to str. I guess, I will just leave them as they are for now. I probably will follow that protocol
in the future.

It just seems that stWho and stWhere do give you the same value on the right had side. I believe it is jones_J. However, There is a table attached (tblUsers) with stWhere. I thought these
values were to only be one. Not a combination of more than one as in the case of stWhere? It just seems confusing.

Respectfully,

Lou Reed

[andy49]

Hope this helps Lou. My comments are in red

stWho = Me.cboAssignee 'sets stWho as the ID of the person who is Assignee
    stWhere = "tblUsers.strUserID = " & "'" & stWho & "'" 'creates a criteria for the where part of the Dlookup and calls is stWhere 
    '-- Looks up email address from TblUsers
    varTo = DLookup("[strEMail]", "tblUsers", stWhere) 'Looks up the email address of the person who's UserID is Stwho. It looks in the stremail column of the tblusers table using the criteria stwhere