Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old October 9th, 2005, 04:16 AM
Authorized User
 
Join Date: Aug 2004
Location: LAKESIDE, California, USA.
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??

Reply With Quote
  #2 (permalink)  
Old October 9th, 2005, 04:21 AM
Friend of Wrox
 
Join Date: Jan 2005
Location: Kansas City, Missouri, USA.
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
Reply With Quote
  #3 (permalink)  
Old October 9th, 2005, 04:29 AM
Authorized User
 
Join Date: Aug 2004
Location: LAKESIDE, California, USA.
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)

Reply With Quote
  #4 (permalink)  
Old October 9th, 2005, 04:34 AM
Friend of Wrox
 
Join Date: Jan 2005
Location: Kansas City, Missouri, USA.
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
Reply With Quote
  #5 (permalink)  
Old October 9th, 2005, 04:38 AM
Authorized User
 
Join Date: Aug 2004
Location: LAKESIDE, California, USA.
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)

Reply With Quote
  #6 (permalink)  
Old October 9th, 2005, 04:42 AM
Authorized User
 
Join Date: Aug 2004
Location: LAKESIDE, California, USA.
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??

Reply With Quote
  #7 (permalink)  
Old October 9th, 2005, 04:42 AM
Friend of Wrox
 
Join Date: Jan 2005
Location: Kansas City, Missouri, USA.
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
Reply With Quote
  #8 (permalink)  
Old October 9th, 2005, 04:43 AM
Authorized User
 
Join Date: Aug 2004
Location: LAKESIDE, California, USA.
Posts: 38
Thanks: 0
Thanked 0 Times in 0 Posts
Default

yes

Reply With Quote
  #9 (permalink)  
Old October 9th, 2005, 04:45 AM
Authorized User
 
Join Date: Aug 2004
Location: LAKESIDE, California, USA.
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
Reply With Quote
  #10 (permalink)  
Old October 9th, 2005, 04:46 AM
Friend of Wrox
 
Join Date: Jan 2005
Location: Kansas City, Missouri, USA.
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
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 07:47 AM
Search in subform webace Access 0 June 12th, 2006 12:52 PM
search on a subform desireemm Access 3 September 21st, 2005 03:44 PM
Filter Subform B Based on Field in Subform A SerranoG Access VBA 3 June 18th, 2004 01:23 AM
search on subform damnnono_86 Access 3 October 28th, 2003 10:34 AM



All times are GMT -4. The time now is 10:11 AM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.