Hi all,

I have a problem that runs along the following lines:

I have custom made an add customer form that will be displayed on my custom main form via changing the subform's SourceObject property.

Now, what im trying to figure out is how to get the subform to perform the following actions when either of the two buttons on the subform are selected:

Add Contact - Updates the Contact table with the new record, then clears the form controls so that the user can enter a new customer.

Cancel - Clears the contents of the form and then closes the subform, i.e. sets the SourceObject to "".

If anyone can help me figure this out i would really appreciate it!