access 2007,
I have a form that is using a table for it's source. In my table I have field names of Company, Cust Name, Addr1, CSZ.
In my form I am using a combox to select the company names.
What I would like to do is when a company name is selected from the combox box on the form the other fields(cust name, addr1, csz) are then populated based on that company name.
I am lost on how this could be done.
Thanks to everyone!
Bruce D.