In the following routine, I am getting an error message..."There is no object in this control" on the txtDateOn = recServices!DateOn
Can someone shed some light here....
Private Sub LoadControls()
' If the file is not empty load up
If Not recServices.BOF Then
' examine the filed under group
cboFiledUnder = recServices!FiledUnder
If recServices!FiledUnder = "Civic Group" Then
CGName.Visible = True
CGName.Enabled = True
CGName.SetFocus
CGName.BackColor = vbYellow
CGName = recServices!CivicGroupName
Else
CGName.Visible = False
CGName.Enabled = False
End If
txtDateOn = recServices!DateOn
txtLastName = recServices!LastName
txtFirstName = recServices!FirstName
txtAddress = recServices!Address
cboCity = recServices!City
cboIssues = recServices!Issues
txtZip = recServices!Zip
txtPhone = recServices!Phone
txtTakenBy = recServices!TakenBy
cboAgency = recServices!Agency
txtReferredTo = recServices!ReferredTo
txtNotes = recServices!Note
txtOrganization = recServices!Organization
txtResolution = recServices!Resolution
txtDays = recServices!DaysActive
txtRecord = recServices.RecordCount & " Records"
txtReviewDate = recServices!DateOn + txtDays
sbrStatus.Panels(3) = txtFirstName & " " & txtLastName & " " & cboIssues & " " & CDate(txtDateOn) + CInt(txtDays)
Else
sbrStatus.Panels(3) = "There are no records on file"
End If
End Sub
Can someone shed some light here....
Private Sub LoadControls()
' If the file is not empty load up
If Not recServices.BOF Then
' examine the filed under group
cboFiledUnder = recServices!FiledUnder
If recServices!FiledUnder = "Civic Group" Then
CGName.Visible = True
CGName.Enabled = True
CGName.SetFocus
CGName.BackColor = vbYellow
CGName = recServices!CivicGroupName
Else
CGName.Visible = False
CGName.Enabled = False
End If
txtDateOn = recServices!DateOn
txtLastName = recServices!LastName
txtFirstName = recServices!FirstName
txtAddress = recServices!Address
cboCity = recServices!City
cboIssues = recServices!Issues
txtZip = recServices!Zip
txtPhone = recServices!Phone
txtTakenBy = recServices!TakenBy
cboAgency = recServices!Agency
txtReferredTo = recServices!ReferredTo
txtNotes = recServices!Note
txtOrganization = recServices!Organization
txtResolution = recServices!Resolution
txtDays = recServices!DaysActive
txtRecord = recServices.RecordCount & " Records"
txtReviewDate = recServices!DateOn + txtDays
sbrStatus.Panels(3) = txtFirstName & " " & txtLastName & " " & cboIssues & " " & CDate(txtDateOn) + CInt(txtDays)
Else
sbrStatus.Panels(3) = "There are no records on file"
End If
End Sub