Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
For i = 0 To Me.cboBrand_ID.ListCount - 1 If Val(Me.cboBrand_ID.Column(0, i)) = Nz(Me.txtAccount_ID, 0) And Val(Me.cboBrand_ID.Column(1, i)) = Nz(Me.txtBrand_ID, 0) And Val(Me.cboBrand_ID.Column(2, i)) = Nz(Me.txtAccountdivision_ID, 0) Then j = True Me.cboBrand_ID.Value = Me.cboBrand_ID.ItemData(i) 'DOES NOT WORK, SINCE itemdata is not unique! Exit For End If Next i
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|managing events in the webrowser control||14||66|
|Handle Apostrophes in VBA SQL - Part 2||10||48|
|error 80020009 - cannot add record(s); join key of table '...' not in record set||5||38|
|Create two calculated fields in a table based on one field entered||4||41|
Join the community of 500,000 technology professionals and ask your questions.