Text boxes to "search" subform

  • Thread starter kimb via AccessMonster.com
  • Start date
K

kimb via AccessMonster.com

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!
 
K

kimb via AccessMonster.com

Thank you, I will give this a try.

Jeanette said:
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
Click to expand...
[quoted text clipped - 9 lines]
Thanks in advance for your help!
Click to expand...
Click to expand...
 
K

kimb via AccessMonster.com

Thank you! So far this is working beautifully!

Jeanette said:
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
Click to expand...
[quoted text clipped - 9 lines]
Thanks in advance for your help!
Click to expand...
Click to expand...
 
Top