I would like to use the same form later in the database to recall my entries and my using the following code I double click on a field (machine) and it should bring up my form which i can view.
Expand|Select|Wrap|Line Numbers
- Private Sub machine_DblClick(Cancel As Integer)
- Dim gstrwhereid As String
- gstrwhereid = "[urn] = " & Me!urn
- 'will open form where id matches line clicked
- DoCmd.OpenForm FormName:="frm_timesheet_header", wherecondition:=gstrwhereid
- DoCmd.Close acForm, Me.Name
- End Sub
Expand|Select|Wrap|Line Numbers
- Me.Dataentry = false
Any help appreciated.
Thanks
Christine.