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 | 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
Thread Tools Display Modes
  #1 (permalink)  
Old March 10th, 2005, 03:56 AM
Authorized User
Join Date: Mar 2005
Location: , , Finland.
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.

Reply With Quote
  #2 (permalink)  
Old March 10th, 2005, 08:35 AM
Friend of Wrox
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,064
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



Reply With Quote
  #3 (permalink)  
Old March 10th, 2005, 08:53 AM
Friend of Wrox
Join Date: Nov 2004
Location: Seattle, WA, .
Posts: 248
Thanks: 0
Thanked 0 Times in 0 Posts

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
Reply With Quote
  #4 (permalink)  
Old March 10th, 2005, 02:06 PM
Friend of Wrox
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,064
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.


Reply With Quote

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
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 08:04 AM
Update Table fields karajian Access VBA 2 December 7th, 2004 02: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

All times are GMT -4. The time now is 12:56 PM.

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