<div>
Use an If Then statement...
</div>


<div>
Something like the below.<br />

<pre><code id="code-302796">SystemUser = GetUser() 'function that gets current Windows log on name
    If nz(DLookup(&quot;FullName&quot;, &quot;tblResources&quot;, &quot;LogonID='&quot; &amp; SystemUser &amp; &quot;'&quot;),&quot;999&quot;)=999 then
          Me!cboRequestor = &quot;&quot;
    else
          Me!cboRequestor = DLookup(&quot;FullName&quot;, &quot;tblResources&quot;, &quot;LogonID='&quot; &amp; SystemUser &amp; &quot;'&quot;)
    End if</code></pre>
</div>


Something like the below.


SystemUser = GetUser() 'function that gets current Windows log on name
    If nz(DLookup("FullName", "tblResources", "LogonID='" & SystemUser & "'"),"999")=999 then
          Me!cboRequestor = ""
    else
          Me!cboRequestor = DLookup("FullName", "tblResources", "LogonID='" & SystemUser & "'")
    End if

<div>
<div class="content wysiwyg-content">
After finally getting Dlookup to work I now realize there is a new problem; &nbsp;I am using Dlookup to &nbsp;match a users Windows log in name with the LogonID in my user table to populate a combo box with the users full name. &nbsp;This is working, however control list only contains my value. &nbsp;If the users logon name does not exist (or has changed) in my user table, the correct name is not populated in the control. &nbsp;How can I check for a match and display a msgbox if not found before populating the control?<br />

<pre><code id="code-302782">SystemUser = GetUser() 'function that gets current Windows log on name
    Me.cboRequestor = DLookup(&quot;FullName&quot;, &quot;tblResources&quot;, &quot;LogonID='&quot; &amp; SystemUser &amp; &quot;'&quot;) ' populates combo box
</code></pre>
</div>
</div>


After finally getting Dlookup to work I now realize there is a new problem;  I am using Dlookup to  match a users Windows log in name with the LogonID in my user table to populate a combo box with the users full name.  This is working, however control list only contains my value.  If the users logon name does not exist (or has changed) in my user table, the correct name is not populated in the control.  How can I check for a match and display a msgbox if not found before populating the control?

Dlookup/Combo box problem

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.