OK folks I am having a serious brain fart here and can't get the code
to do what I really want done. I have a form that has a multi-table
query as its data source. The data is dsplayed on the form as a
series of text boxes and combo boxes. I want to have a button that
when clicked will search the previous control (as long as it is one of
the text boxes or combo boxes that contain data) for the text the user
requests. The search should only be performed on the data displayed
in the given previous control. If the previous control is a text box,
the serach should look for the requested text in the bound field. If
the previpous control is a combo box, the serach should look for the
requested text in the field displayed in the combo box, hoever I dont
want it to serach the available values in the combo box, I want it to
search the records for any who have the selected valeu containing the
search text. If it would help any I can put a hidden text box with
the displayed data element of the combo box somewhere on the form.
Anyone want to take a stab at this?
Thanks...