I have a contact form with several tabbed subforms. On the Calls tab there is a form with a "notes" field. I'm trying to make a popup search form that will return all the customers with certain "keywords" in the notes field on their call info tab.
The notes field is NOT in the underlying querey for the master Contact form...so I'm confused. I think I need to make a new recordset....maybe by using the SQL statemnet below on the Calls form....then applying that recordset to the other form....whew..is it that complicated????
I believe I need this SQL statement in there somewhere....
"SELECT * FROM Calls " _
& "WHERE NOTES LIKE '*" & txtFind & "*'"
except that this is the path to the field
Forms![Contacts]![Calls].Form![Notes]
I'm totally confused...HELP PLEASE???
The notes field is NOT in the underlying querey for the master Contact form...so I'm confused. I think I need to make a new recordset....maybe by using the SQL statemnet below on the Calls form....then applying that recordset to the other form....whew..is it that complicated????
I believe I need this SQL statement in there somewhere....
"SELECT * FROM Calls " _
& "WHERE NOTES LIKE '*" & txtFind & "*'"
except that this is the path to the field
Forms![Contacts]![Calls].Form![Notes]
I'm totally confused...HELP PLEASE???
