I am writing an application which is a POS system. the application is made up of 2 components; an executable that contains the client interface(forms) and a dynamic link libary that contains the data services.

I am using one class module to access the database. All data retrieved using the class module is added to a collection. The collection is then used on the form.

When I add information using the form the database is updated fine. But I can't seem to work out how to update the collection with the new information.

Any help would be much appreciated