arunakumari02
Registered User.
- Local time
- Today, 15:36
- Joined
- Jun 2, 2008
- Messages
- 91
I have to populate txtfields on the form from the table.
I have table and want to select rows for which the check box (i.e. optimizer) is checked
Here is the code:
When Debugging it shows:
1
109 Mav 2 PPQ Nonvalidated PPQ test
1
109 Mav 2 PPQ Nonvalidated PPQ test
120 Mavk India Recertification Support
Fact:
I have 4 records in the table which are checked but in the record count it shows only one and do not loop.
Any help is appreciated
I have table and want to select rows for which the check box (i.e. optimizer) is checked
Here is the code:
Code:
'Populating the fields
strSQL = "SELECT ProjectID, Title, Owner, Optimizer From tblProjects where [Optimizer]=True"
Set rstProjects = CurrentDb.OpenRecordset(strSQL)
Debug.Print rstProjects.RecordCount
rstProjects.MoveFirst
Debug.Print rstProjects!ProjectID & " " & rstProjects!Titl
Debug.Print rstProjects.RecordCount
For intRow = 1 To rstProjects.RecordCount
Forms!frmPipeline!("chkOptimizer" & intRow) = True
Forms!frmPipeline!("txtProjectID" & intRow) = rstProjects!ProjectID
Forms!frmPipeline!("txtTitle" & intRow) = rstProjects!Title
Forms!frmPipeline!("txtOwner" & intRow) = rstProjects!Owner
Debug.Print rstProjects!ProjectID & " " & rstProjects!Title
rstProjects.MoveNext
Debug.Print rstProjects!ProjectID & " " & rstProjects!Title
Next
rstProjects.Close
When Debugging it shows:
1
109 Mav 2 PPQ Nonvalidated PPQ test
1
109 Mav 2 PPQ Nonvalidated PPQ test
120 Mavk India Recertification Support
Fact:
I have 4 records in the table which are checked but in the record count it shows only one and do not loop.
Any help is appreciated
Last edited by a moderator: