Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
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 March 10th, 2005, 04:56 AM
Authorized User
Join Date: Mar 2005
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Suomi
Default Viewing certain fields of table in another pan

Hi all,

*I have 3 tables with multiple fields. The tables have relationship among them.
*DISPLAY PAN: I want to view certain fields of a table in a view. I want it to be a viewing window where I can scrol down and can go up and down.
*When I select any value of the DISPLAY PAN, correspoding info from another table's fields are displayed in another pan/window.

Is it possible to have this kind of view in ACCESS? I have little bit knowledge of VB.
so far I am having this impression that ACCESS report are just like pdf pages... u can't have the kind of view as i m looking for.
Thank you very much in advance.

Old March 10th, 2005, 09:35 AM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

Wow, you do need some Access books. Beginning Access books.

Click on any of your tables and click the AutoForm button. That will create a FORM to look at your tables the way you want in your request (Form, Subform). You don't want a report to look at table data.

Then switch to design view and add a combo box using the combo box wizard to allow you to find records on your form.

Then add this code to the Form's On Click event


    cboYourLookUpComboBox = YourTableID



Old March 10th, 2005, 09:53 AM
Friend of Wrox
Join Date: Nov 2004
Posts: 248
Thanks: 0
Thanked 1 Time in 1 Post

mmcdonal is right about the books. And is right about the combo box.

Since you mentioned wanting to see a scrolling list you should also be aware that you can use a list box instead of a combo box.

You can also use two subforms (a.k.a. Child forms). This option is a little more sophisticated but provides more flexibility in that it is easier to display several fields in your list (another thing you said you wanted).

One subform will list your first "view" or DISPLAY PAN. When an item is selected there you'll have code that updates a hidden field on the parent (master) form. The other subform will use the master / child link fields to display data from your other table(s) according to what gets put into that hidden field.

For just a little investment of time looking at some examples of this kind of stuff, and maybe cracking open a book or two, I think you'll find great rewards in how quickly and easily Access can put together forms to present data.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
Old March 10th, 2005, 03:06 PM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts


   BTW, if you click on a look up table and then click autoform, it will create the subform as well. That is where I was going with that.



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to obtain fields of a certain table? MTLedari ASP.NET 2.0 Professional 2 September 27th, 2007 03:56 PM
Fields in a dynamic table? Roshu Javascript How-To 12 January 10th, 2005 09:04 AM
Update Table fields karajian Access VBA 2 December 7th, 2004 03:48 PM
Updating table fields ppenn Access VBA 2 September 20th, 2003 06:09 PM
Listing the Fields in a table John Anthony Access VBA 1 July 4th, 2003 08:42 AM

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