List/Select Form

[Guest]

Is there any way in Access to create a List/Select form where it lists
everything and you can select from that and explode into a more detailed
form???

Let me know.

Thanks!

 

[Shaun Beane]

How much do you know about Access VBA?

You could create a form with a listbox displaying the List of items to
select from - like customers. Then on the doubleclick event of the list
box, open the detail form and find the select customer from the list box
using the appropriate properties.

You'll need to be pretty comfortable with at least the basics of VBA.

Shaun Beane, MCT, MCDBA

 

[Albert D. Kallal]

It really depends. Often, in place of a treeview, I will use two sub-forms
side by side.

You can see some screen shots of this idea here:
http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm