Call form directly from from Table(Datasheet)

  • Thread starter Thread starter RT
  • Start date Start date
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
 
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
 
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
 
Back
Top