Help Please - Selecting Field in Subform to call up Another Form

  • Thread starter Thread starter tmdrake
  • Start date Start date
T

tmdrake

I have a subform that if you double click on the Last Name it pulls up
another form displaying all the records for that Name.

This works, however I want the form that is being called up to display in
datasheet view. I have the Default view set at Datasheet but the form comes
up in single form. How do I change this.

Also why is it when you double click on the Last Name a parameter box pops
up with the Last Name as the title and you have to type the name in again
then the form appears. How do I stop the parameter box from showing and
after the double click the form in datasheet view just pops up.
 
I'm sorry here is the code I'm using to accomplish this:

Private Sub LastName_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stLinkCriteria = Me.LastName
stDocName = "frmProjectStaffingDetails"
DoCmd.OpenForm stDocName, , , "LastName = " & stLinkCriteria

End Sub

Help is greatly appreciated.

Thanks
 
Back
Top