Click on a record in a subform datasheet to open another form displaying info related to that record

  • Thread starter Thread starter edself
  • Start date Start date
E

edself

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 said:
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!
Click to expand...

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.
 
Back
Top