I have a form that i need some help on.
I have 5 fields consisting of Account Number, Company Name, Address, City and Zip Code.
I would like to be able to enter the account number in the form and have the corresponding information filled in automatically.
Like a VLOOUP in excel with the account number being the lookup value, I dont know if there is a vlookup in Access. Any help would be appreciated.
Thanks
Jmo422
I have 5 fields consisting of Account Number, Company Name, Address, City and Zip Code.
I would like to be able to enter the account number in the form and have the corresponding information filled in automatically.
Like a VLOOUP in excel with the account number being the lookup value, I dont know if there is a vlookup in Access. Any help would be appreciated.
Thanks
Jmo422