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:47 AM
Authorized User
 
Join Date: Aug 2004
Posts: 38
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I tried that but it didnt work

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

I cant send you the database cause our information is confidential. I wish I could though :(

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

yeah but thats the tab control what about the subform??

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

Ok.
When you are using a main form and connecting records, the recordset in the subform is only those records related to the main form. So if you select an I/R on the main form, only those subjects related to that I/R are available on the sub form.

Make sense?

Kevin

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

yes I understand that. Should I just get rid of the subform then?
 
Old October 9th, 2005, 03:59 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

Since the subform has a tab control, you can only see one subject at a time correct?

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

yes the one pertaining to that I/R number

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

thanks again for your help on this
 
Old October 9th, 2005, 04:11 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

Desireemm,

If there are many subjects related to that I/R number, and you are trying to search those subjects, you should be able to do that, but without being able to see your database, it's difficult to figure out how to go about it. If you create another form, use the subjects table as the recordsource. Create a dropdown to search the subjects. Use your current subform as a subform on this new form. Once you get that to work, then, use the new form as a subform on the I/R form instead of the one you're using now. Does that make any sense?

Kevin

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

I guess creating an advanced search feature would be what I have to do. I just want to be able to search by more then just the mainform, but also the subform






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.