command button 2007

[mugziegumz via AccessMonster.com]

Brand new with access-
How can I create a command in datasheet form to open another form? Is this
possible? I tried doing the command in datasheet view/form but it didn't work.

I'd like to create a command next to each person's name. So if I clicked on
their last name in datasheet view-it'd open to a new form with lots more
detail.
Step by step instrucitons please!

 

[Tom van Stiphout]

On Wed, 26 Nov 2008 01:35:03 GMT, "mugziegumz via AccessMonster.com"

No, a form in datasheet view cannot have buttons. Use a ribbon.
Perhaps not for an absolute newbie.

If you click - I would suggest double-click - the LastName, the
LastName_DblClick event occurs. THere you can open a new form.
Something like:
docmd.OpenForm "MyNewForm",,,"PersonID=" & Me.PersonID

-Tom.
Microsoft Access MVP

 

[Damon Heron]

The easiest way is to use the double-click event on the field (person's
name)
Private Sub YourField_DblClick(cancel as integer)
Dim stDocName As String
Dim strWhere As String

stDocName = "Your Form Name"
strWhere = "[Person] = " & "'" & Me.YourField & "'"

DoCmd.OpenForm stDocName, , , strWhere

end sub

Damon

 

[mugziegumz via AccessMonster.com]

Where do I put this command? Being brand new with access-can I copy and paste
this info somewhere in my command? Thanks.
Shannon

The easiest way is to use the double-click event on the field (person's
name)
Private Sub YourField_DblClick(cancel as integer)
Dim stDocName As String
Dim strWhere As String

stDocName = "Your Form Name"
strWhere = "[Person] = " & "'" & Me.YourField & "'"

DoCmd.OpenForm stDocName, , , strWhere

end sub

Damon

Brand new with access-
How can I create a command in datasheet form to open another form? Is this

[quoted text clipped - 6 lines]

detail.
Step by step instrucitons please!