I have a customers page and a jobsheet page,
the customers page is where the information on the customer is stored e.g. "Company" ,"First name" and "Last name".
When I Go into jobsheet, I have made it in so that company searches for the record from access so there is a list e.g. "Big W" , "Bunnings" etc, and tied up to the company is a name of the person in that company.
My question (after all the babble) is how can I make it so when I choose "Big W" from the list, it auto fills in the "First name" combo box with 'John' and last name combo box with 'Smith' , also the same for phone number and address and if I choose Bunnings it uses the name associated with that and etc for the other companies.
Cheers for help in advance.
the customers page is where the information on the customer is stored e.g. "Company" ,"First name" and "Last name".
When I Go into jobsheet, I have made it in so that company searches for the record from access so there is a list e.g. "Big W" , "Bunnings" etc, and tied up to the company is a name of the person in that company.
My question (after all the babble) is how can I make it so when I choose "Big W" from the list, it auto fills in the "First name" combo box with 'John' and last name combo box with 'Smith' , also the same for phone number and address and if I choose Bunnings it uses the name associated with that and etc for the other companies.
Cheers for help in advance.