Debug error in Richards developer 5 lesson 2, where if employee is moved from ComList1, to ComList2. Getting syntax error on DoCmd.RunSQL "UPDATE CommissionT SET IsSelected=TRUE" & _ " WHERE CommissionID=" & ComList1
Got this error following the lesson, then have rebulit, from begging with new form, three times getting the same result. I will attach screen shot of the statement. Have checked all spelling. What is wrong with is?
Larry WalleyOP
@Reply 3 months ago
Larry WalleyOP
@Reply 3 months ago
Developer 5 Lesson 2, IsSelected to be sent from ListBox1 to ListBox2. Keep getting same debug error. Can someone help?
Thanks Larry
Kevin Robertson
@Reply 3 months ago
You are missing a line of code before the line that is highlighted.
You need to make sure the List Box is not Null.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Developer 5.
