Forms and Subforms

[Cleaver]

Any help that can give will be VERY appreciated. I have a
form that has the main form and a subform. The main form
has Customer ID and Customer name and is linked to the
Customer Information table. The Customer ID box is set up
as a combo box and is connected to the Customer Name so
that it feels in the Customer name when the Customer ID is
selected.

I then have a subform that has system information for each
of the customers. Each form works great independently and
when I don't use a combo box.

When there is no combo box on the main form it
automatically displays the correct information in the
subform. However, I need a combo box because this form is
going to be used to update system information and I want
the user to be able to choose the correct customer. I
need the customer ID box on the subform to update
automatically with the Customer ID box on the main form.
What is the code I would use or how would I go about doing
this?????

Thanks again for any advice anyone can offer.

Christina

 

[Estuardo]

-----Original Message-----
Any help that can give will be VERY appreciated. I have a
form that has the main form and a subform. The main form
has Customer ID and Customer name and is linked to the
Customer Information table. The Customer ID box is set up
as a combo box and is connected to the Customer Name so
that it feels in the Customer name when the Customer ID is
selected.

I then have a subform that has system information for each
of the customers. Each form works great independently and
when I don't use a combo box.

When there is no combo box on the main form it
automatically displays the correct information in the
subform. However, I need a combo box because this form is
going to be used to update system information and I want
the user to be able to choose the correct customer. I
need the customer ID box on the subform to update
automatically with the Customer ID box on the main form.
What is the code I would use or how would I go about doing
this?????

Thanks again for any advice anyone can offer.

Christina
.

Christina:
I'm going to dare to make sugestions, because is not
common to sichronize the Parent form with the Child form.
Besides, i think that this is the reason why you can not
work with a cbobox in your parent form. and its because
you have no links between your forms.(PKCustomer id in
the parent and FKCustomer in the child form).

I guess so because linking the forms you wont need to
sinchronize the parent form with the child.

What i mean is not common to sinchronize the forms in
that order. Child --> Parent, but it is the opposite
order Parent--> child.
Try to link the forms and see the results.

Otherwise what you want will have to be really hard coded
in your subform. i think is better if you change some of
the structre in your forms.

Good luck
Estuardo