I have 2 unbound text boxes on a form (named f_search). They are named:
txtSerial and txtTrack. In the footer of the form, I have a subform (named
f_subsearch) that I want to display information from table Registration
Master. I want a user to be able to type either in the txtSerial or txtTrack
boxes, click a button and the results display in the subform, (pulling the
info from Serial# or Tracking# fields from the Registration Master table). I
have no idea how to write the code for this to work. I have tried several
different examples and I have not been able to get them to work. Any
suggestions would be greatly appreciated.
Thanks in advance for your help!
kimb,
see if the sample search form at this site
http://allenbrowne.com/ser-62.html
gives you some ideas.
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
>I have 2 unbound text boxes on a form (named f_search). They are named:
> txtSerial and txtTrack. In the footer of the form, I have a subform (named
[quoted text clipped - 9 lines]
>
> Thanks in advance for your help!
kimb - 29 Jul 2008 21:53 GMT
Thank you, I will give this a try.
>kimb,
>see if the sample search form at this site
[quoted text clipped - 8 lines]
>>
>> Thanks in advance for your help!

Signature
Thanks,
Kim B.
kimb - 30 Jul 2008 21:45 GMT
Thank you! So far this is working beautifully!
>kimb,
>see if the sample search form at this site
[quoted text clipped - 8 lines]
>>
>> Thanks in advance for your help!

Signature
Thanks,
Kim B.