MS Access - Search Record

PatAccess

Registered User.
Local time
Yesterday, 19:56
Joined
May 24, 2017
Messages
284
Hello Guys,

I need quick help. Here is my code
Private Sub Command8_Click()
DoCmd.OpenForm "Frm_RMFCommunicationList", acNormal, , "[ORGANIZATION]='" & Me.txtOrg & "'"
End Sub

What operator should I use if I want the return records that has the word entered within that string?

For instance: If I type "University" in the field and click command8, I want all the record to come back that have that word in it so like ABC University, DEF University, etc.

Thank you,
 
DoCmd.OpenForm "Frm_RMFCommunicationList", acNormal, , "[ORGANIZATION] LIKE '*" & Me.txtOrg & "*'"
 
Great Thank you
 

Users who are viewing this thread

Back
Top Bottom