recordset - list box error (for search record)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

this form use to show to search a certain record in frmFindQuoteSheet and
after seleting in listbox(frmFindQuoteSheet) they will click the cmdFind to
pull the record and the form frmQuoteSheetMaster form appeared with the
selected record.

I'm having run time error 2450
Can't find form 'frmQuoteSheetMaster' referred to in a macro expression or
visual basic code. Thank you so much in advance....

Private Sub cmdFind_Click()

Dim frm As Form
Dim rst As Object

Set frm = Forms!frmQuoteSheetMaster
Set rst = frm.Recordset.Clone
rst.FindFirst "[Placing_ID] = " & "'" & lstFind & "'"
Forms!frm.Bookmark = rst.Bookmark
DoCmd.Close acForm, "frmFindQuoteSheet"

End Sub
 
Hi zweet18
This error I faced myself when using data from one form as input for the
other.
It acutally tells you that the form can not load the data as it is not active.
so...
first open the form by
DoCmd.OpenForm "frmQuoteSheetMaster"
and then pass through the data.

success,
Harry
 
It works!Thank u so much..... I really appreciate u're help.....

Harry said:
Hi zweet18
This error I faced myself when using data from one form as input for the
other.
It acutally tells you that the form can not load the data as it is not active.
so...
first open the form by
DoCmd.OpenForm "frmQuoteSheetMaster"
and then pass through the data.

success,
Harry

zweet18 said:
this form use to show to search a certain record in frmFindQuoteSheet and
after seleting in listbox(frmFindQuoteSheet) they will click the cmdFind to
pull the record and the form frmQuoteSheetMaster form appeared with the
selected record.

I'm having run time error 2450
Can't find form 'frmQuoteSheetMaster' referred to in a macro expression or
visual basic code. Thank you so much in advance....

Private Sub cmdFind_Click()

Dim frm As Form
Dim rst As Object

Set frm = Forms!frmQuoteSheetMaster
Set rst = frm.Recordset.Clone
rst.FindFirst "[Placing_ID] = " & "'" & lstFind & "'"
Forms!frm.Bookmark = rst.Bookmark
DoCmd.Close acForm, "frmFindQuoteSheet"

End Sub
Click to expand...
Click to expand...
 
Thanks again Harry

Harry said:
Hi zweet18
This error I faced myself when using data from one form as input for the
other.
It acutally tells you that the form can not load the data as it is not active.
so...
first open the form by
DoCmd.OpenForm "frmQuoteSheetMaster"
and then pass through the data.

success,
Harry

zweet18 said:
this form use to show to search a certain record in frmFindQuoteSheet and
after seleting in listbox(frmFindQuoteSheet) they will click the cmdFind to
pull the record and the form frmQuoteSheetMaster form appeared with the
selected record.

I'm having run time error 2450
Can't find form 'frmQuoteSheetMaster' referred to in a macro expression or
visual basic code. Thank you so much in advance....

Private Sub cmdFind_Click()

Dim frm As Form
Dim rst As Object

Set frm = Forms!frmQuoteSheetMaster
Set rst = frm.Recordset.Clone
rst.FindFirst "[Placing_ID] = " & "'" & lstFind & "'"
Forms!frm.Bookmark = rst.Bookmark
DoCmd.Close acForm, "frmFindQuoteSheet"

End Sub
Click to expand...
Click to expand...
 
Back
Top