D
deb
I am using a listbox to find a record. Person chooses the criteria in a
listbox and clicks the button and the record appears in the form. My main
form is fProject and the subform is f000Deliverable.
This works great in any main form. But now I am trying to use it in a
sub-form, and I get an error "Cant find the form f000Deliverable referred to
in a macro expression or VB code"
Private Sub ShowRecord4_Click()
Dim Rst As DAO.Recordset
' Store the recordset for the form.
' Set Rst = Forms!f000Deliverable.RecordsetClone
' Locate the record for the selected.
Rst.FindFirst "DelivID = " & List4
' Set the form's Bookmark property to move to the record.
Forms!f000Deliverable.Bookmark = Rst.Bookmark ' Problem starts is here
' Close the dialog box.
DoCmd.Close acForm, "f000DelivGoTo"
End Sub
Please help
listbox and clicks the button and the record appears in the form. My main
form is fProject and the subform is f000Deliverable.
This works great in any main form. But now I am trying to use it in a
sub-form, and I get an error "Cant find the form f000Deliverable referred to
in a macro expression or VB code"
Private Sub ShowRecord4_Click()
Dim Rst As DAO.Recordset
' Store the recordset for the form.
' Set Rst = Forms!f000Deliverable.RecordsetClone
' Locate the record for the selected.
Rst.FindFirst "DelivID = " & List4
' Set the form's Bookmark property to move to the record.
Forms!f000Deliverable.Bookmark = Rst.Bookmark ' Problem starts is here
' Close the dialog box.
DoCmd.Close acForm, "f000DelivGoTo"
End Sub
Please help