In short : Form has been created and works well. Need to automate it a bit to ease work flow. I need my user to be able to select a Vendor ID at the top of the form, then have it auto fill the firm name, address, etc. This info will be contained in a spread sheet in the same directory (if Excel is an option) Would rather not use Access because not everyone has it.
Trouble Is, I know it SHOULD work, but am new to the program and am unsure HOW to make it work. If pointed in the right direction, I can usually figure it out.