Records aren't being retrieved.

  • Thread starter Thread starter LAS
  • Start date Start date
L

LAS

I have a straightforward form whose record source is as follows. When I
click "run" while looking at it in the query builder two rows are retrieved.

SELECT tblStudentTracking.* FROM tblStudentTracking;

Below is the code in a button on the form. When it is executed the
RecordCount is 0 and the BOF/EOF test is true. Can anyone tell me what I'm
doing wrong?

TIA
LAS

Me.Requery

Set irst_StudentTracking = Me.Recordset

With irst_StudentTracking
gi_Debug = .RecordCount
If (.EOF = True) And (.BOF = True) Then
.AddNew
!Student_ID = cboStudent_ID
!Incident_Date = "#" & txtStartDate & "#"
End If
End With
 
I started my form over, and copied controls and scripts one by one and the
rows are retrieved as expected in the new form. So I guess it was just one
of those Access corruptions.
 
Back
Top