ListBox (1 Viewer)

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??
 

Users who are viewing this thread

Top Bottom