Accessing a sub-form

S

Speedy

I have a table or list form which shows various records which represent a
sort of index to further data which is then diplayed in a sub-form as the
text content is large (over 500 characters). Note that there is only one
file with all data therein.

The reason to show the main form in list or table view is to allow the user
to see the maximum amount of records in one screen like when one would look
in an index to a book. A record is then selected and it should call the
sub-form based on a the index reference i.e. the detail text relating to the
index reference.

Any idea how to do this simply (i.e. least code) and elegantly (user
friendly)?

Speedy.
 
A

Arvin Meyer [MVP]

You can do it with no code by using a form view of what Microsoft has
provided for tables. I prepared a sample and set it on my demo website for
you to look over. The data comes from the Microsoft Northwind sample
database:

http://www.accessmvp.com/Arvin/Sample.zip

The trick to building it is to:

1. Allow subdatasheets in the tables
2. Create the main form as a datasheet.
3. In the main form Design View create the subform as a datasheet.
4. Place the main form as a subform on an overall main form.
5. Save, view, and adjust.
6. Change the innermost subform to single form view.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top