SELECT UID
FROM listEmployeeKey
WHERE KeyID=Forms!formKey!txtKeyID;

SELECT *
FROM tblAssets

SELECT tblAssets.ID, IIf(Not IsNull(tblAssets.NetName),tblAssets.NetName,tblAssets.ModelID)

SELECT tblAssets.ID, IIf(Not IsNull(tblAssets.NetName),tblAssets.NetName,tblAssets.ModelID) AS Name, tblAssets.SN
FROM tblAssets
WHERE (((tblAssets.UID)=[Forms]![formSupport]![cboUID])

SELECT tblAssets.ID, tblAssets.ModelID AS Name, tblAssets.UID
FROM tblAssets
WHERE (((tblAssets.NetName) Is Null) AND ((tblAssets.Status)="In Use" Or (tblAssets.Status)="Open" Or (tblAssets.Status)="Repair" Or (tblAssets.Status)="Stored"));

Private Sub formSupport_OnCurrent()

On Error GoTo Err_Update_Click

    Me![listAssetSupportHistory].Requery
    Me![listUserSupportHistory].Requery
    
Exit_Update_Click:
    Exit Sub

Err_Update_Click:
    MsgBox Err.Description
    Resume Exit_Update_Click

Private Sub cboDept_AfterUpdate() 
    ' Filter records in cboSubDept based on selection in cboDept 
    Dim subDeptSource As String 
  
    If Me.cboDept.Value (does not equal null)