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 February 8th, 2006, 01:58 PM
Authorized User
 
Join Date: Jan 2006
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts
Default Help! With multiple subforms

I'm using a form to display the results of my query. What I need is the results to be displayed with columns & rows(pretty much the way it looks after you run the query). But I need to be able to scroll through them if there is many and have the user be able to select anyone one of the records & based on the selection have it look up & search an image table automatically based on a value(in a cell)in the record that has been selected in the subform1. I would like the results of that to be displayed in either another subform2 or perhaps a list box. The results would only return a value from one field but there could be a list of multiple drawings as a result.

Does that make any sense?
and do I need to use Subforms?
Is there other ways to accomplish this?

Any help would be greatly appreciated.

-dale

 
Old February 8th, 2006, 04:38 PM
Authorized User
 
Join Date: Jan 2006
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I've managed to return the value of the paticular record in the subform1 I'm selecting but how do I get my subform2 to update when I click on my cmdFind button?

 
Old February 8th, 2006, 06:12 PM
Friend of Wrox
 
Join Date: Dec 2005
Posts: 142
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Did you set the master/child fields?






Similar Threads
Thread Thread Starter Forum Replies Last Post
Subforms 150563a Access 1 June 29th, 2007 04:57 AM
Edit Forms with Master/Multiple SubForms natwong Access 1 February 27th, 2007 01:01 PM
subforms ajmil11 Access 2 January 19th, 2006 11:16 PM
Subforms V Access VBA 1 April 21st, 2004 11:48 AM





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