Upgrade to SQL server - forms to be based on queries rather than filters?

[P_Henry]

I am in the process of upgrading Access b/e to SQL b/e using .mdb and linked table as the front end ( as given as the best solution in many of the posts).

I remember reading in this forum ( Comment made by Pat Hartman) that forms should be based on queries rather than using a filter criteria.

I have a continuous form with project records. The user can double click one of the records to view further details of the project on a separate form. The code I have used to open the form is as follows:

strdocname = "frmProjDetails"
strParm = ""
strLinkCriteria = "[WProjNo]=" & "'" & Me![ProjNo] & "'"

DoCmd.OpenForm strdocname, , , , acFormEdit, , strParm

Would this be a reduction in performance? Should the record source of the details form be changed to a query that has a where clause pointing to the selected record?
Thanks...Priya

 

[P_Henry]

Any one able to answer this...help needed please.