Multiple Record View

[Jwy]

I'm new to Access and need some help. I'm trying to duplicate a Lotus Notes view using Access. That is, I want to display multiple records of the database, similar to the datasheet view, but only certain fields of the database and filtered. When the user clicks on the record they want to display or edit, the single document form will display for that record. Is this doable in MS Access? Any help is appreciated.

 

[edtab]

Yes, this doable in Access, however, not that easy to accomplish
if you are new to Access. As a start, you should research how to make
forms and subforms work together. Once you master this part, then
you should move on to adding an "onclick" event in your subform
that will display the selected record on your main form. You place it on
the field that is common to record sources of your main form and the subform.

Search the forum for "forms and subforms" and you might turn up more
information to help you in achieving your desired result.

 

[Jwy]

Thanks, works like a charm. Is there a way to add a button to the datasheet view to close the form and return to the switchboard? I tried adding this to the form header but can't seem to get it to display.