Search and Display

[Guest]

I need a search table capability on a form. However, I do not want the form
to update the table. I tried using unbound list and combo at various times.
Problem is I have about 10 fields. I need to be able to search the different
fields so I tried using multiple unbound text boxes on the form with (combo
or list). My problem is that I could get the text box to search for (key
number) column(0), but not other fields. Can anyone help?


Thanks

 

[Tom Wickerath]

This sounds like you are wanting Query by Form capability, where you build the WHERE clause using
VBA code. This is not the same as the rather limp QBF that is built into Access. The more
advanced QBF technique is covered in many advanced Access books, such as Scott Barker's
"Microsoft Access {version} Power Programming". I suggest you spend some time at a local
bookstore and pick out one or two advanced Access developer books. The how-to-do-it would be a
bit much for attempting to answer in a newsgroup post. If you want to send me a private e-mail
message, I'll be happy to send you a sample database with QBF functionality.

Tom

AOS168 at comcast dot net
_____________________________________


I need a search table capability on a form. However, I do not want the form
to update the table. I tried using unbound list and combo at various times.
Problem is I have about 10 fields. I need to be able to search the different
fields so I tried using multiple unbound text boxes on the form with (combo
or list). My problem is that I could get the text box to search for (key
number) column(0), but not other fields. Can anyone help?


Thanks