Find/Search record using listbox and view it in mainform

[marjerie888]

Hi everyone

Need help!I have 2 forms in form2(frmFindQuoteSheet) Im using lisbox to select the record that they want to view in form1(frmQuoteSheetMaster)when I click the cmdFind I'm having an "error runtime error 424"

form1 = frmQuoteSheetMaster
form2 = frmFindQuteSheet

Please anyone can help i'm new in access...Thank u in advance......
----------------------------------------

Private Sub cmdFind_Click()

Dim rst As Object

Set rst = frmQuoteSheetMaster.Form.RecordsetClone
rst.FindFirst "[Placing_ID] = " & "'" & lstFind & "'"
frmQuoteSheetMaster.Form.Bookmark = rst.Bookmark
DoCmd.Close acForm, "frmFindQuoteSheet"

End Sub

 

[TheAceMan1]

How are ya marjerie888 . . .

Can't tell if [blue]frmQuoteSheetMaster[/blue] is a subform or not. Please specify!

If it is a subform then you should have:

[blue]   Dim rst As DAO.Recordset, sfrm As Form
   
   Set sfrm = Forms![purple][b][i]MainFormName[/i][/b][/purple]!frmQuoteSheetMaster.Form
   Set rst = sfrm.RecordsetClone
   
   If rst.BOF Then
      MsgBox "No Records!"
   Else
      rst.FindFirst "[Placing_ID] = " & "'" & lstFind & "'"
      
      If rst.NoMatch Then
         MsgBox "Record Not Found! . . ."
      Else
         sfrm.Bookmark = rst.Bookmark
         DoCmd.Close acForm, "frmFindQuoteSheet"
      End If
   End If[/blue]

See Ya! . . . . . .

Be sure to see FAQ219-2884: