By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,647 Members | 1,178 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,647 IT Pros & Developers. It's quick & easy.

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

P: n/a
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!

Ed Self


Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
It's easy to do with a continuous forms view, and using double click -- that
is illustrated in the sample databases for image handling in Access that you
can download from http://accdevel.tripod.com. I use a common procedure
called from the double-click event of each control and the detail section
itself so a double-click anywhere on the line will open the detail form. In
that procedure, you pick up the unique id and construct a DoCmd.OpenForm
statement's WhereCondition.

Larry Linson
Microsoft Access MVP

"edself" <ed****@ecomail.org> wrote in message
news:N2rwb.293192$Tr4.926313@attbi_s03...
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!

Ed Self

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.