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.

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

'=====

HTH

mmcdonal

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
http://www.pnwadg.org

Yep,

   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.

Thanks,


mmcdonal