I have a database where I would like to enter a job title in a text box and see it's report.
Currently this works if I enter the job title exactly as it is in the database. But I'd like to enter just a section of text like "director" and the reports for the job containing that term.
Here is the code I'm using now that works:
DoCmd.OpenReport "Job Summary", acViewPreview, , "Title = '" & [Forms]![JobGroups]![txtJobTitle] & "' "
How would I alter this, or what other statements can I use to open the report where a substring of Title = txtJobTitle?
Thanks for any help!
Currently this works if I enter the job title exactly as it is in the database. But I'd like to enter just a section of text like "director" and the reports for the job containing that term.
Here is the code I'm using now that works:
DoCmd.OpenReport "Job Summary", acViewPreview, , "Title = '" & [Forms]![JobGroups]![txtJobTitle] & "' "
How would I alter this, or what other statements can I use to open the report where a substring of Title = txtJobTitle?
Thanks for any help!