asked on

MS Access Forms drill down

Is it possible to display records in a Form - 1 record per line so that the user clicks on one of the records and an underlying screen pop ups with more detail. The user would need to be either navigate up or down the tabular detail with a command bar across the screen or directly click on the record to activate the subform. I have seen the Selector Add In which partially does this, but it does not allow for fields within the records to be formatted differently (different colours etc) which I also need. I also need the ability to have a command button displayed along each record down the page which would invoke more functionality for that particular record.

mbizup

Use a form in continuous forms view. You can set the default view to continuous forms by opening your form in design view, opening the croperties window, and setting the default view (under the format tab). You can select different colors for the controls either through the controls property sheet. You can also use conditional formatting (select a textbox or other control in design view and go to format -> conditional formatting). This wil allow you to set text or background color if certain conditions are met.

To open the other form, you can use a command button, like you said, or the double click event (or another event) of a text box,etc with the following VBA:

docmd.openform

garryv

ASKER

Thanks for this.

Is there a way to make this more consistent with how this functionality works in other applications like having a highlighted command bar that is displayed right across all fields in the record. The user can up and down arrow the bar and either click or hit enter to open the underlying form.

Further to this is changing the mouse pointer to indicate that a click is possible over the line. Just using the on click event doesn't present the user with this.

ASKER CERTIFIED SOLUTION

Leigh Purvis

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial