how to populate specific fields on a Form from with information from another table

[abiola]

I have two tables and two forms. Table1 contains some information that have been previously populated via form1. Table2 will be partly completed by a user via form2, I would like certain fields on form2 to automatically populate with information contained in Table1 based on a selection by the user. The User will then complete the rest of form2 manually.

To be more precise, there are 9 fields in form2 and Table2. Based on Table1 information I will like the user to select an ID from a lookup (which I have done already), but have the corresponding Name, Last name and actual amount to automatically populate on the form2. then the user will manually complete the rest of the form and then save the information in table2.

Any ideas, how I can go about doing this will be well appreciated. Many thanks

 

[abiola]

Hi Uncle Gizmo, Yes it is based on a combo box. any idea will be welcome.

 

[Singh400]

Couldn't this be achieved by basing the form on a query that pulls the relevant information from the respective tables?

 

[abiola]

Hi Singh400, can you explain more how your suggestion of using a query will be achieved? thanks