I agree with Steve; if you want to enter one search term and have nine fields searched using it, your database is almost assuredly non-normalized, and you first order of business, here, has to be addressing this issue first! Failure to do this will make most anything you need to do take ten times longer than it should, and may make some tasks impossible.
How about giving us some specific details on your data, especially the nine fields to be searched.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007