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.

 

[Pat Hartman]

Create a query that selects only the columns you want to show in the datasheet view. Add an order by to specify how the data should be sorted.

Create a form with the new query as its recordsource and specify datasheet view (use the wizard, it will be easier).

Add code to the double-click event of one of the fields. I use the double-click rather than the click because the double-click is less likely to ba accidental. This code will open another form in single form view. If you don't know how to do this, add a button and let the wizard build the code to open a form to a particular record. Then copy the code and paste it in the double-click event.

 

[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.

 

[Pat Hartman]

Datasheet forms don't display headers or footers so there is no place to put a button. For that reason, I generally embed my datasheet forms in another form so I can put the buttons on the main form. The datasheet form then becomes a subform. Don't forget, if you have any external references to it, once the form becomes a subform, they will need to be changed.