MS Access Forms drill down

Posted on 2006-04-11
Medium Priority
Last Modified: 2006-11-18
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.
Question by:garryv
LVL 61

Expert Comment

ID: 16432706
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:


Author Comment

ID: 16432836
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.
LVL 44

Accepted Solution

Leigh Purvis earned 200 total points
ID: 16432890
Or indeed - it sounds like the Current event in the continuous form (or datasheet if you preferred) would be appropriate - responding to navigation or row clicking.

Not entirely sure what you mean by "having a highlighted command bar that is displayed right across all fields in the record".
It sounds like a selected record in a listbox.
But then you'd lose all your formatting options (and a host of events).
You could try simulating that - but it would have to be a datasheet rather than a continuous form and using a line of code like

DoCmd.RunCommand acCmdSelectRecord

(But then in a datasheet you'd lose your command button on each row... but a single command button outside of the form used as a subform would work)

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question