Search feature

[Loyola]

I have a form into which I would like to embed a search
feature that would look up a record in the form based on
the user typing some criteria into an input box that
would match one of the fields in the record, thus finding
the record. I have a macro that triggers upon the input
box losing focus, but in the macro design field where it
says "find what", what expression should I enter to tell
it to retrieve the record based on the criteria the user
typed?

Thanks to all who can help,

Loyola

 

[Upendra Agnihotram]

Dear Loyala,

you can achieve the functionality by writing some VBA Code behind the form.

Txt_Input

Update the Forms Record source by using the Where condition to search the
input value

For Example :

If you have Two forms, in the master form u will key-in the text to be
searched,
Based on the user's input you will requery the subform.

If you are not able to understand, I will post the entire code.

Regards,
Upendra

 

[Loyola]

Yes, could you? That would be very helpful. I have just
begun studying VBA in a class at College, but I'm not
quite there yet!
Thanx you so much!

Loyola