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.
-- 
tmdrake

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
-- 
tmdrake


"tmdrake" wrote:

> 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.
> -- 
> tmdrake