how do I open a form showing immediately show right data

[Guest]

Say, form A and form B are related to each other. Can form B be opened to
show relevant data only (data in form B that is related to data in Form A).
Can this be done ? How.

 

[Guest]

ayob,

This is normally done by embedding Form B as a subform on Form A, and
setting the subform's LinkMasterFields and LinkChildFields properties to the
name of the related field in the main and subform, respectively.

For example, to show Orders of a Customer, place a continuous subform based
on Orders on a main form based on Customer, and set the two properties equal
to the name of the Customer primary key and the related foreign key in
Orders. This would normally be something like CustID in each.

If this doesn't help you solve your problem, provide more detail on your
tables and their relationship.

Sprinks