Stephen Bond
stephen at bondsoftware.co.nz
Sun Feb 19 18:03:30 CST 2012
Here's the whole Sub if that helps: ================================================ Sub FillGridSpecificJobObservations(ByVal pk) Dim strSQL As String Set rs = New ADOdb.Recordset Set rs.ActiveConnection = CurrentProject.Connection rs.CursorType = adOpenStatic rs.LockType = adLockReadOnly rs.CursorLocation = adUseClient strSQL = "SELECT qryEquipmentRegisterRHS.JobId, " & _ "qryEquipmentRegisterRHS.ObservationId AS ObsId, " & _ "qryEquipmentRegisterRHS.ObserverName AS ObservName, " & _ "qryEquipmentRegisterRHS.ObserverDate AS ObservDate, " & _ "qryEquipmentRegisterRHS.ObserverTime AS ObsTime, " & _ "qryEquipmentRegisterRHS.Shift, " & _ "qryEquipmentRegisterRHS.Id" strSQL = strSQL & " FROM qryEquipmentRegisterRHS " strSQL = strSQL & " WHERE qryEquipmentRegisterRHS.JobId = " & pk & ";" rs.Open strSQL rs.Sort = "ObsId Asc" SortAsc = True Set Me.DataGridSpecificJobObservations.DataSource = rs ' <--- runtime error on this line Me.DataGridSpecificJobObservations.Refresh Set dg = Me.DataGridSpecificJobObservations dg.Font.Size = 8 dg.RecordSelectors = False dg.Columns(0).Width = 0 ' JobId dg.Columns(1).Width = 500 ' ObservationId dg.Columns(2).Width = 1800 ' Name dg.Columns(3).Width = 1000 ' Date dg.Columns(4).Width = 800 ' Time dg.Columns(5).Width = 450 ' Shift (was S or U) dg.Columns(6).Width = 0 ' Id ' dg.Columns(5).NumberFormat = "currency" dg.Columns(3).NumberFormat = "dd/mm/yyyy" dg.Columns(4).NumberFormat = "hh:nn" dg.Columns(3).Alignment = 2 dg.Columns(4).Alignment = 2 dg.Columns(5).Alignment = 2 dg.MarqueeStyle = 3 If rs.RecordCount = 0 Then ' Me.Toolbar1.Buttons("Edit").Enabled = False Else ' Me.Toolbar1.Buttons("Edit").Enabled = True End If End Sub =================================