Call form directly from from Table(Datasheet)

R

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
 
R

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
 
A

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?)
Click to expand...

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
 
Top