|
-
October 2nd, 2001, 10:54 AM
#1
???
Hi
I have another question. Can ANYONE tell me how these two lines of code are connected to the following block of code? If I comment these two lines out, my grid fills with data as it's supposed to (but then another forms blows) If I leave it in, my grid does not fill. I am baffeled.
ElseIf IsNumeric(strStatement) Then
ValidSQL = strStatement
Private Sub cmbSite_Click()
With cmbSite
If .ListIndex > -1 Then
grdSchedule2.Enabled = True
LoadScheduleGrid
'Update DateLastCreated label for the schedule file
Set qd = db.QueryDefs("SelectDTScheduleFileCreated")
qd!pSiteNumber = Left(cmbSite, 7)
Dim rs
Set rs = qd.OpenRecordset
If rs.RecordCount = 0 Then
lblDateLastCreated = vbNullString
Else
lblDateLastCreated = rs!DateLastCreated
End If
rs.Close
Set rs = Nothing
qd.Close
Set qd = Nothing
End If
End With
End Sub
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|