One form in datasheet view, one form in regualr form view....

[mugziegumz via AccessMonster.com]

All the templates provided have the option to click on the ID number to open
up the details/form. How can I make this on my form? Please view a template
of Access 2007 if I'm not making sense.
It'd be so nice to just be able to click on a person's name in the datasheet
form view and have another more detailed form pop up.
Can someone tell me how to do this?

 

[Mike Painter]

All the templates provided have the option to click on the ID number
to open up the details/form. How can I make this on my form? Please
view a template of Access 2007 if I'm not making sense.
It'd be so nice to just be able to click on a person's name in the
datasheet form view and have another more detailed form pop up.
Can someone tell me how to do this?

The templates use a built in function in 2007.
You can't do what you want in a datasheet view but you can create a
continuos form subform that looks like a datasheet and opens a form or links
to a subform.
It is done with either the on-click or ondouble clickevent.

The Northwind database has examples.

 

[mugziegumz via AccessMonster.com]

What is the Northwind database?
How do I create a continuous form/subform?
Thank you.

 

[Mike Painter]

The Northwind database is added when you install Access. It is filled with
examples and is part of teh massive amount of help available with Access.
You create a continuous subform by selecting that option as the default view
on the property sheet for the form.
With Access 2007 it is listed as a "Multiple Item" in the form section on
the create tab on the ribbon.