Hello all
I have Two tables.Table 1 and table 2.Table 1 has one to many relation with Table 2.I have one main form Form1 based on table 1.On form 1 i have a sub form based on table 2.I have put a find record button on main form i.e Form 1.Master/child relation is already established.Find button works fine with main form.it changes the main form entries and the sub form entries accordingly.this button doesnot work with sub form.this means that if i want to find a specific record from sub form,it does not show that and the main form entries are also not changes.
Requirement.
whenever the find button on main form is clicked with an entry from subform record,all related records from subform is shown and the main form records which relates to subform record is also shown.