oskar_diaz
Registered User.
- Local time
- Today, 08:57
- Joined
- Jul 28, 2003
- Messages
- 18
I am populating a list box and i want it to reffer to a record on another form. the list box has a Id, and name on it. i want it to double click the name and open that specific record.
this is me code
Private Sub cmdFind_Click()
Dim rst As DAO.Recordset
'find the record and then close the dialog box
Set rst = Forms!frmDataHouse.RecordsetClone
rst.FindFirst "PhysId = " & "'" & lstFind & "'"
Forms!frmDataHouse.Bookmark = rst.Bookmark
DoCmd.Close acForm, "frm_DataEntryForm"
Set rst = Nothing
End Sub
im getting a form cant be found. but that is the name of
the form frmDatahouse
anyone??
this is me code
Private Sub cmdFind_Click()
Dim rst As DAO.Recordset
'find the record and then close the dialog box
Set rst = Forms!frmDataHouse.RecordsetClone
rst.FindFirst "PhysId = " & "'" & lstFind & "'"
Forms!frmDataHouse.Bookmark = rst.Bookmark
DoCmd.Close acForm, "frm_DataEntryForm"
Set rst = Nothing
End Sub
im getting a form cant be found. but that is the name of
the form frmDatahouse
anyone??