Open Form using search criteria
Posted on 2006-05-11
I'm trying to open a record based off the search criteria in a list box. The search form is MyForm and the record source is querySPInfo the list box is bound to the field ServicePartner. In the list box the rowsource is SELECT tbldServicePartners.ServicePartner FROM tbldServicePartners ORDER BY [ServicePartner];. When the user double clicks on a value in the list box, I want it to open the editing form with the details from that selected record. The double click command is
Private Sub ServicePartner_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmSPEdit", , , "ServiceParter=" & ServicePartner
However, i am getting a runtime error 3075.
Can you help me fix this?