Hello,
Your 'idiot-proofing forms' series was simply amazing so I decided to get the course! I used that series to create a form for myself. In one of the episodes you mentioned about searching for the ID to return all the information in the database.
The command you showed:
Set Rng = dataIdCol.Find(What:=SearchValue, _
LookIn:=xlValues, _
LookAt:=xlWhole, _
SearchOrder:=xlByRows, _
MatchCase:=False)
If Not Rng Is Nothing Then
How would I restructure or change the code so it pulls out text instead of numerical values? I've tried searching up solutions but am struggling to find the one that works.
Thanks in advance!