I have a form which displays a subform datasheet of information. I'd like
to be able to quickly click on a particular record and open up another form
showing more detailed information about that record from a related table.

Is there a way to do this? It would be nice to be able to right click on a
cell in a datasheet and then select menu choice to open a form with related
information, but it seems like to right click menues in Access are hardwired
for Access application functionality.

Is there some other way to accomplish the same thing? Again, I just want to
be able to quickly click on a record/cell in a datasheet and open another
form to view expanded information related to that record from a different
table/query.

Thanks in advance for your help!

"edself" <(E-Mail Removed)> wrote in message
news:KpXvb.282545$Fm2.292260@attbi_s04...
> I have a form which displays a subform datasheet of information. I'd like
> to be able to quickly click on a particular record and open up another
form
> showing more detailed information about that record from a related table.
>
> Is there a way to do this? It would be nice to be able to right click on
a
> cell in a datasheet and then select menu choice to open a form with
related
> information, but it seems like to right click menues in Access are
hardwired
> for Access application functionality.
>
> Is there some other way to accomplish the same thing? Again, I just want
to
> be able to quickly click on a record/cell in a datasheet and open another
> form to view expanded information related to that record from a different
> table/query.
>
> Thanks in advance for your help!

You can use the OnClick event for this but I usually use the doubleClick
event.
Just place the command in each column you want them to open from.
If there is room on the form you might also want to look at another subform
on the main form that is controlled by the first form.
Most people prefer this either because they use it a *lot* or use it so
rarely they forget about the double click.

Which OnClick event do I use? This is a subform datasheet. Will it be the
OnClick event for the underlying combo box that represents a column in the
datasheet? Are you saying that if I click on a cell in a subform datasheet,
that the onclick event for the underlying combo box will be triggered? If
that is true, then how would I determine which record (row) was clicked? I
will need to know this so I know which record to query for the new form to
be opened.

"Mike Painter" <(E-Mail Removed)> wrote in message
news:iRYvb.100545$(E-Mail Removed)...
>
> "edself" <(E-Mail Removed)> wrote in message
> news:KpXvb.282545$Fm2.292260@attbi_s04...
> > I have a form which displays a subform datasheet of information. I'd
like
> > to be able to quickly click on a particular record and open up another
> form
> > showing more detailed information about that record from a related
table.
> >
> > Is there a way to do this? It would be nice to be able to right click
on
> a
> > cell in a datasheet and then select menu choice to open a form with
> related
> > information, but it seems like to right click menues in Access are
> hardwired
> > for Access application functionality.
> >
> > Is there some other way to accomplish the same thing? Again, I just
want
> to
> > be able to quickly click on a record/cell in a datasheet and open
another
> > form to view expanded information related to that record from a
different
> > table/query.
> >
> > Thanks in advance for your help!
>
> You can use the OnClick event for this but I usually use the doubleClick
> event.
> Just place the command in each column you want them to open from.
> If there is room on the form you might also want to look at another
subform
> on the main form that is controlled by the first form.
> Most people prefer this either because they use it a *lot* or use it so
> rarely they forget about the double click.
>
>