Call form directly from from Table(Datasheet)

[RT]

Years ago if I remember correctly in a Dos based database program (Clarion?)
I was able to scroll down through a table to any particular record, then
push a key combo (I think it was Ctl-Enter or possibly Enter) and have the
related form and record pop up onscreen.

Is there anyway to do this in Access?

RT

 

[Roger Carlson]

In Access 2000 and above, there is a feature call subdatasheets which will
do that. When subdatasheets are enabled and when there are related records,
there will be a + sign at the beginning of the record. Clicking the plus
will display the related records.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Albert D. Kallal]

It is not clear if you mean by related records the classic term one to many
relation.

When you hit the key sequence, are you trying to display the existing record
as a nice from to edit, or are you looking to do a drill down to display he
"many" side of a one to many relationship?

You can certainly flip from data sheet view to form view to display, and
edit the current record.

You can also built a form that displays results..and have button, or even
the enter key open up a form to that one record.

Years ago if I remember correctly in a Dos based database program
(Clarion?)

Probably Reflex comes to mind.

Anyway, here is some ideas and examples of "grids" of data:
http://www.attcanada.net/~kallal.msn/Articles/Grid.htm