Started working on this lesson today and ran into a problem with the OptionList displaying options. I have the coding prepared like the video and the handbook. Looked over the OptionT, ProductT, and CategoryT in the chance that something was entered incorrectly, and I cannot find the problem. I even ran the debug on it, and nothing came up. I have attached screenshots from Code, Online Video, and my database, which I am working on.
Ken WykoffOP
@Reply 9 months ago
Ken WykoffOP
@Reply 9 months ago
Ken WykoffOP
@Reply 9 months ago
Kevin Robertson
@Reply 9 months ago
You are missing an opening parenthesis before CategoryID in ProductList_AfterUpdate()
Ken WykoffOP
@Reply 9 months ago
Again, Kevin, thanks for the great catch! Appreciate your help
Paul Kiener
@Reply 9 months ago
Ken, Also add the line "Option Explicit" at the top of your code, immediately after "Option Compare Databases".
Ken WykoffOP
@Reply 9 months ago
Thanks Paul, I keep forgetting that.
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 14.