Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 9th, 2005, 03:16 AM
Authorized User
 
Join Date: Aug 2004
Posts: 38
Thanks: 0
Thanked 0 Times in 0 Posts
Default Search a Subform

I have a relational database with a main form and a subform. And my problem is I cant search on the subform part. I cant use the Find feature on the subform I created the find record from the wizard and it works great on the main form but on the subform I cant get it to search anything. It will only Find Records on the Subform.

Help??

 
Old October 9th, 2005, 03:21 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

Desireemm,

What exactly are you trying to find on the subform? Do you have a parent - child relationship between the main form and the sub-form? I. E. Employee info on the main form and dependents on the subform?

Kevin

dartcoach
 
Old October 9th, 2005, 03:29 AM
Authorized User
 
Join Date: Aug 2004
Posts: 38
Thanks: 0
Thanked 0 Times in 0 Posts
Default

yes there is a child relationship. the subform is on a tabcontrol. the subform has names of subjects I need to search by. The main form is the Investigators findings and the subform is the subjects involved in the findings (usually theres more then one)

 
Old October 9th, 2005, 03:34 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

When you say the main form is the Investigators findings, is there something you are searching on the main to get to those findings? Then, the sub-form - is all the data on the tab control (regardless of which tab) coming from 1 table?

Kevin

dartcoach
 
Old October 9th, 2005, 03:38 AM
Authorized User
 
Join Date: Aug 2004
Posts: 38
Thanks: 0
Thanked 0 Times in 0 Posts
Default

no theres two tables. the main form has a I/R number that you use to search the findings that number is unique and the primary key in the mian form (Reports_table)

 
Old October 9th, 2005, 03:42 AM
Authorized User
 
Join Date: Aug 2004
Posts: 38
Thanks: 0
Thanked 0 Times in 0 Posts
Default

seems as though by default you cant use the Find Record on a subform which is on a tabcontrol. Is there a way to override that, some code or something??

 
Old October 9th, 2005, 03:42 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

So the second table contains all the information about the findings and is related to the first table by the I/R number?


dartcoach
 
Old October 9th, 2005, 03:43 AM
Authorized User
 
Join Date: Aug 2004
Posts: 38
Thanks: 0
Thanked 0 Times in 0 Posts
Default

yes

 
Old October 9th, 2005, 03:45 AM
Authorized User
 
Join Date: Aug 2004
Posts: 38
Thanks: 0
Thanked 0 Times in 0 Posts
Default

one I/R number can have more then one subject and the subjects information
 
Old October 9th, 2005, 03:46 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

Desireemm,

How big is your database? Can you zip it up and send it to me?
A tab control is like a field on a form. You can adjust the tab control size, and put another dropdown on top of it to search the records.

Kevin

dartcoach





Similar Threads
Thread Thread Starter Forum Replies Last Post
New text search doesn't preselect search string planoie Visual Studio 2005 0 July 23rd, 2007 06:47 AM
Search in subform webace Access 0 June 12th, 2006 11:52 AM
search on a subform desireemm Access 3 September 21st, 2005 02:44 PM
Filter Subform B Based on Field in Subform A SerranoG Access VBA 3 June 18th, 2004 12:23 AM
search on subform damnnono_86 Access 3 October 28th, 2003 10:34 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.