Account is text, so added the necessary quotes and that fixed it. Thanks for pointing that out! Now i just need to see if I can get it to write to the table. The drop down is working now though!
Thanks for the help boblarson.
G37Sam, I'm new to VBA, so I will give that a shot next time. Thanks.