Need to assign an object from one form to a collection in a different form

[timothyriggs]

Building a CRM in Access 2007 with a MySQL backend. Have several objects defined, one of which is the Customer object, another is the Jobs object. The Customer object has a collection of Jobs objects in it's declarations. Customer calls in, user opens New Customer form and inputs the relevant contact information and a list of properties owned by the customer. Opening this form creates a new Customer Object.

For each property entered the customer can put in a Work Request. This is handled by a 2nd form. The 2nd form takes all the data about the particular work request and puts it into a Jobs object. What I need to be able to do is copy the Jobs object in the Request form into the collection in the Customer object on the first form, when the Request form is closed. I simply cannot use a subform control as it would make the initial form far to unwieldy and cumbersome. These need to be handled on separate forms.

One thing I did try was creating a new Jobs object in the Customer form when the Request form is opened, and assign the values that way, but I know of no way to initiate the call to add that new object to the collection when the Request form is closed.

Any ideas are GREATLY appreciated.

[cyberdwarf]

Hi Timothy

Could you pls post the structures og your Customer and Jobs objects

Steve

[timothyriggs]

Customer object
Option Compare Text
Public fname As String '
Public lname As String '
Public cid As String '
Public dob As String '
Public user As String '
Public calldate As String '
Public status As String '
Public track1 As String '
Public track2 As String '
Public addr As String '
Public city As String '
Public state As String '
Public zip As String '
Public email As String '
Public cphone As String '
Public hphone As String '
Private ConnString As String
Private Enum exist
rNew = 1
rOld = 0
End Enum
Public properties As Collection
Public appts As Collection
Public jobs As Collection


Jobs object
Option Compare Database
Public jobid As String
Public q1 As String
Public q2 As String
Public q3 As String
Public q4 As String
Public q5 As String
Public q6 As String
Public q7 As String
Public q8 As String
Public q9 As String
Public status As String
Public pid As String
Public cid As String

Those are the declarations in the class modules. Do you need functions as well? Customer is a fairly large size and growing.

[timothyriggs]

I figured it out. Made a module to initialize a Customer object. Call the function to set it in w/e form starts the process i'm working on and then I can use the object thru the lifetime of the operation.