Dynamically synchronise 2 forms to return info

[Gsm]

Does anyone know how i can synchronise two forms so that i
have a main form (a form that logs calls) and a form that
pops up through a button (to enable me to select a known
customer who is calling).

Once a customer is selected in the popup form this
information will then dynamically be shown in the Main
form.

Any suggestions would be appreciated

Gavin

 

[Jeff Boyce]

Gavin

If your "requirement" is to select a known customer from the full set you
have, why do you need an entire form for that? Have you looked into using a
combo box filled with a list of names (and other identifying info)?

You haven't provided an idea of your underlying table structure -- if you
would, 'group readers may be able to offer an alternative that could make
your forms construction somewhat easier.

 

[Gsm]

Okay the question was maybe a little vague that i posted
earlier.

I need to create a form that is used to log calls. This
will be made up of call time, call duration, call
escalation type etc.

The plan is that when a call comes in the customer is
selected and their call details such as telephone number
and address are shown.

Originally i had planned to create a combo box from which
the customer could be selected and a linked combo box
showing all known contacts (employees)associated with that
customer.

The problem is that there needs to be the option to create
new customers other than ones which already reside in the
customers table.

This is the reason i was thinking that creating two forms
linked dynamically so that when new customers are created
then it can be automatically placed on the form used to
log calls.

Gavin

p.s. The tables Which are linked are Calls, Customer, &
Contacts

 

[Jeff Boyce]

Gavin

Check into using the NotInList event -- if you put a "new" customer in the
combo box, you can intercept that to allow the addition of that new
customer.