refresh subform

[roh_8_it_3]

Hi All,

I have one main form in which i have 2 subforms on different tabs.All the forms are unbound. Basically i am trying to assign a order to multiple persons.SO the main form has the order information.1st subform shows the already assigned persons and the second one is for assigning new persons.

The problem i am having is that whenever i assign a new person using the second subform i want to refresh the first subform but i am failing in it.

i used forms!firstsubform!refresh on the second subform..but it says object doesnt support the property or method.Then i create a refresh button on the first subform and on its click event i m doing me.refresh but again its failing.

The first subform is not bound and it has datasource as a querry like select a,b,c from order where orderid=txtorderid.

Any help on this pl.thanks

 

[RuralGuy]

Close! forms!firstsubform.Form!refresh
http://www.mvps.org/access/forms/frm0031.htm

 

[andrewleith1]

where about do you put the code?
i also have a sub form that needs to have a refresh button
thanks

 

[RuralGuy]

If the Link Master/Child fields are set properly then the refresh/requery is taken care of by Access.

 

[andrewleith1]

RG could you please explain the "Link Master/Child fields "

 

[RuralGuy]

SubForms are displayed on forms by means of a SubFormControl. On the data tab of the property sheet for this SubFormControl are two special properties: Link Master Fields and Link Child Fields. These properties are for fields on the parent and child form that will keep the parent and child forms synchronized. If you look up 'Link Master Fields' in VBA help there is a fairly good explaination about these properties.

 

[andrewleith1]

thanks for your wisdom

 

[RuralGuy]

It is worth every penny you paid for it! Good Luck with the rest of your project.