Displaying information based on selection

[Connor Roberts]

Im not very experienced on Access so i have been looking through the forum to see if anyone had resolved an issue I have been having, I did come across some similar situations which I tried to apply to mine however im still having problems. I think it may be the coding I tried using.

On my form I would like the user to be able to select a company, and once the company has been selected I would like a box to display all the contact information for the specific company. I would also like this box to record the contact information onto my database along with the other information that will be gathered on the same form.

I have provided screen shots to help. The Contacts and Companies are linked with the COSYSNO and CoSysNo fields.

Thanks in advance
Connor

 

[Pat Hartman]

Welcome aboard
You need a form to display the company data and a subform for the contacts.