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

Checked Box Problem

100+
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
rsOrdered.MoveFirst
Do While Not rsOrdered.EOF

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


If Not rsOrdered.EOF Then
rsOrdered.MoveNext
End If

Loop

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


100+
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.