Hi,
Very new with Access. I am trying to create a few dlookups, but I can't seem to get things right. The best I could do is get the information from the first row even when the criteria does not match that row.
This is the code that is associated with the combo box:
Option Compare Database
Option Explicit
Private Sub ClientINTI_AfterUpdate()
RelaTWO = DLookup("RelationshipTwo", "ClientInfo", "ClientINTI= '" & ClientINT & "'")
NameTWO = DLookup("FullNameTwo", "ClientInfo", "ClientINTI= '" & ClientINT & "'")
End Sub
I attached the database.
Wrote in some more explanation on the form in the database.
A great thanks to anyone that can help!!