I have a DB of Job Positions and I am trying to create a form that the users can enter keywords in multiple fields, then hit a search button to receive a report with all the Positions that match all their criteria.
I've tried binding the form to the Table, the Query and not binding it at all. The fields in the form are all unbound. I have a SEARCH button that takes me to a Report, but no matter what I have in the form fields, the report always comes up with ALL the Positions. I've also tried several ways to put criteria in the query..."*", with [Keyword?] or [forms]![formname]![fieldname]; but I don't know how to do the [forms]!... criteria making the [fieldname] so it will pickup parts of words, etc. (does that make sense?)
It is probably something right in front of my nose, but I'm just not seeing it. I have been all thru MS Help, The FAQ's and Searches on this site and even some from MS's knowledge base. Can anyone help explain this in beginners terms. I am a "LITTLE" familiar with SQL, so I'm looking for the easiest way, without a Parameter Box poping up.
Thank you sooo much.
I've tried binding the form to the Table, the Query and not binding it at all. The fields in the form are all unbound. I have a SEARCH button that takes me to a Report, but no matter what I have in the form fields, the report always comes up with ALL the Positions. I've also tried several ways to put criteria in the query..."*", with [Keyword?] or [forms]![formname]![fieldname]; but I don't know how to do the [forms]!... criteria making the [fieldname] so it will pickup parts of words, etc. (does that make sense?)
It is probably something right in front of my nose, but I'm just not seeing it. I have been all thru MS Help, The FAQ's and Searches on this site and even some from MS's knowledge base. Can anyone help explain this in beginners terms. I am a "LITTLE" familiar with SQL, so I'm looking for the easiest way, without a Parameter Box poping up.
Thank you sooo much.
