Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / July 2008

Tip: Looking for answers? Try searching our database.

Text boxes to "search" subform

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kimb - 25 Jul 2008 21:18 GMT
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!
Jeanette Cunningham - 25 Jul 2008 23:50 GMT
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.

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.