search subform record based on master record

Hello

I have a subform and i need to change record when i change master form record.... but when i change master form record, subform record doesnt change... i tried with filter option but useless... kingly guide...

You need to set the Master Child links of the forms to whatever field you use to relate the records.

Dear, during navigation of master record, child form record changes. but during change of master record by combox box (master field), child records dont change...... this is my problem....

It shouldn't make any difference.
I have a combo box search that changes the master form, but it always maintains the correct subform record.
What is your combo doing?

dear if u have combobox as unbound control, it works fine. but if u have bound combobox, it did not retrieve child records in subform

Is the bound combo for entering data?

no, it is bound column but if record already present , it retrieves data..

I am sorry, I can't see the point of the bound Combo, surely it is better to have the Subform working properly?
How do you relate the data that is in the 2 forms, via the Key field of the Master table?

There are a few ways to get the subform to follow the master form. The basic way is to inspect the properties of the main form and while in design view, choose the subform control and display the master/child properties. Set these to a common field and you should be done.&lt;br&gt;<br>
&lt;br&gt;<br>
However, you might also be using a control on the subform to link to the main form. if this is the case, I suggest you opt for the option above. But if you insist, you can attempt to reset the sourceobject of the subform using the on current event of the main form. Something like this: me.subform.sourceobject = "subformname"&lt;br&gt;<br>
&lt;br&gt;<br>
Another approach you might be using is for the subform to have a criteria of a system table. For instance, in the query view of the recordsource of the subform, you might be doing a 'dlookup("currentidfield","zstblInformation") in the criteria or simply linking fields in the query grid. If this is the case, then the main form's on current event needs to reestablish the correct value for the subform. Something like 'currentdb.execute "update zstblinformation set currentfield = " &amp;amp; me.id&lt;br&gt;<br>
&lt;br&gt;<br>
Let me know if I can help more&lt;br&gt;<br>
&lt;br&gt;<br>
Jack Jaeger&lt;br&gt;<br>

Crossposted with replies https://www.access-programmers.co.uk.../#post-1738913

Did you get the answer you needed?

Jack

https://www.datacontrolllc.com

Ueah, It will be good to know.