I'm planning on making a change to my database by adding a form which allows me to do the following...
On the form itself I would like a combo box or a list view (preferably) which shows 2 columns, contract ID's and Client Names which are stored in a table.
When a particular record is selected from the combo box, I would like the contents of that record in the table shown on the currently loaded form. Obviously, when selecting another client, the form is updated.
Where should I start with this? Should the form be based on a query, or a re-query, or...???
many thanks!
On the form itself I would like a combo box or a list view (preferably) which shows 2 columns, contract ID's and Client Names which are stored in a table.
When a particular record is selected from the combo box, I would like the contents of that record in the table shown on the currently loaded form. Obviously, when selecting another client, the form is updated.
Where should I start with this? Should the form be based on a query, or a re-query, or...???
many thanks!
