Records aren't being retrieved.


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
 
Ad

Advertisements

L

LAS

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top