One form in datasheet view, one form in regualr form view.... "mugziegumz via AccessMonster.com" <u47747[ at ]uwe> 11/23/2008 9:25:08 PM 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? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200811/1

Re: One form in datasheet view, one form in regualr form view.... "Mike Painter" <mddotpainter[ at ]sbcglobal.net> 11/23/2008 10:46:25 PM mugziegumz via AccessMonster.com wrote: [Quoted Text] > 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.

Re: One form in datasheet view, one form in regualr form view.... "mugziegumz via AccessMonster.com" <u47747[ at ]uwe> 11/24/2008 1:58:11 AM What is the Northwind database? How do I create a continuous form/subform? Thank you. Mike Painter wrote: [Quoted Text] >> 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. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200811/1

Re: One form in datasheet view, one form in regualr form view.... "Mike Painter" <mddotpainter[ at ]sbcglobal.net> 11/26/2008 10:17:46 PM 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. mugziegumz via AccessMonster.com wrote: [Quoted Text] > What is the Northwind database? > How do I create a continuous form/subform? > Thank you. > > Mike Painter wrote: >>> 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.