Refresh Subform

[DeVille]

Hi
I have this sub form on a Tab in my main form, (there is
a one to may relationship between the sub form(one) and
the main form(many)) there is a drop down box on the main
form which I can use to select a customer ID, which
should bring up the customer details in the sub-form,
except that after I have select the Customer ID, the
customer details do not appear strait away in the sub
form, I have to go to the next record then when I come
back the details have appeared in the sub form, I any one
can help me with some code to refresh the sub form when
make the selection in my combo box in the main form
thanks in advance.

 

[Matt Weyland]

on the click event of the object on the parent form try
adding the following line of code.

on the subform property set the Link Child Field and Link
Master Field to the FK/PK (CustomerID) relation ship of
the two tables.

If all else fails turn on the wizard on the toolbox.
Create a duplicate of your parent form. The insert a
subform and let the wizard walk you through it.

Hope this helps.

Matt Weyland
Data Analys
Stratis Health
(e-mail address removed)