So, you need to filter
NOT to search. This are two different tasks.
Also, I'm not sure that you know the difference between macro
in Access (in Excel is the same thing).
By using VBA this can be a solution:
Design a public
function (in a standard module) that return a boolean value.
Public Function FilterRecords(N As String, D As String, OB As String, AT As String) As Boolean
Dim FindWhat As String
FindWhat = Forms!Search_Query!Text17 & ""
If FindWhat = "" Then
FilterRecords = True
FilterRecords = True 'Perform OR . Change to False if you wish AND
If Instr(1,N,FindWhat) Then
If Instr(1,D,FindWhat) Then
If Instr(1,OB,FindWhat) Then
If Instr(1,AT,FindWhat) Then
FilterRecords = False 'Perform OR . Change to True if you wish AND
Base your form to a query.
In this query add one more field SelectThisRecord:FilterRecords([Notes],[Description],[OpenedBy],[AssignedTo])
In the Criteria put True
In the form use the AfterUpdate event for the Text17 control or (better) design a button and use the Click event to requery the form.
Note please two things:
1) I have removed the spaces from the names. You should do the same in your database. If you wish to keep actual names you must adapt the code to the names with spaces. Don't ask me how to do this because I don't know.
2) This code is not tested.
Good luck !