By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,973 Members | 1,528 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,973 IT Pros & Developers. It's quick & easy.

Checked Box Problem

P: 134
I create a continue form which show all customer back order. I also have a bound checkbox from the same table.

I am trying out the checkbox correctly,

For example if the first attempt I checked 2 rows and click the Submit button, it show me the 2 records checked correctly with the back order qty correctly.

On the 2nd attempt, if I removed one checkbox and remain the other checked and click the button again, it show nothing been checked, what wrong with my code.

Dim rsOrdered As New ADODB.Recordset
Dim strSQL
Set cnOrdered = CurrentProject.Connection

strSQL = "SELECT * from tblinvoicelines WHERE checkme = -1"
Set rsOrdered = cnOrdered.Execute(strSQL)

If Not rsOrdered.EOF Then
Do While Not rsOrdered.EOF

If checkme = -1 Then
MsgBox (rsOrdered!Invoice)
MsgBox (rsOrdered!BackOrder)
MsgBox ("Not checked " & rsOrdered!Invoice)
MsgBox (Me.checkme)
End If

If Not rsOrdered.EOF Then
End If


Set rsOrdered = Nothing
Set cnOrdered = Nothing
Dec 21 '06 #1
Share this Question
Share on Google+
1 Reply

P: 134
It Alright guy, I solved the problem.
Dec 21 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.