Hi .. I'm trying to do something pretty basic (I think) and just wondering if anyone can help me..
I wish to search a remote table (holidays) that contains a list of dates for a date value that is given on my current form.. if its there I wish to lock the subform I have for editing.. but I'm getting object required errors.. would anyone have some suggestions?
Dim rs2 As ADODB.Recordset
Set rs2 = Me.RecordsetClone
rs2.Find "[Job Date] = #" & Format(Holidays![Holiday Dates], "dd/mm/yyyy") & "#"
If rs2.BOF Or rs2.EOF Then
Me.EditJobsfrm.Locked = False
Else
Me.EditJobsfrm.Locked = True
End If
I wish to search a remote table (holidays) that contains a list of dates for a date value that is given on my current form.. if its there I wish to lock the subform I have for editing.. but I'm getting object required errors.. would anyone have some suggestions?
Dim rs2 As ADODB.Recordset
Set rs2 = Me.RecordsetClone
rs2.Find "[Job Date] = #" & Format(Holidays![Holiday Dates], "dd/mm/yyyy") & "#"
If rs2.BOF Or rs2.EOF Then
Me.EditJobsfrm.Locked = False
Else
Me.EditJobsfrm.Locked = True
End If