Using select instead of dlookup

[lcline]

Thanks in advance,

In the past i have used dlookup to find specfic fields from a table.

I was thinking that a select statement would be more efficient as I need to return 4 fields for one specific record.

I tried the following but keep getting error 3061 Too Few Parameters Expected 1.

My question is which is more efficent 4 dlookups or the select method.

If the answer is the select method, why am I getting the error.

SelectSql = ("SELECT dbo_R_D_Event_Date.RID," _
& " dbo_R_D_Event_Date.Install_Shift, dbo_R_D_Event_Date.Station," _
& " dbo_R_D_Event_Date.Install_Emp" _
& " FROM dbo_R_D_Event_Date" _
& " WHERE dbo_R_D_Event_Date.PartID ='" & Me.txtInstall & "'")

Set rs = CurrentDb.OpenRecordset(SelectSql)

thanks again