Base each form on a query.
Both are select Queries
The first or master form should have a control on it that referes to the
master link on the 1 side of the one to many critria.
In the uderlying query of the second or minor form, point the many side of
the query to the control on the master form. This way, when you select the
master records, you many form will only show the records that matct the
masters form control.
In the many field of the forms underlying query, set the criteria to:
Forms![MasterForm]![UniqueLinkControlName]
Lets for example say you master forms control select record 12356
Then your minor forms underlying query will show all records 12356 for your
minor form
I know this explanation is as clear as mud but if you can work it out it
will work.
hth Mike B
--
Advice to Posters.
Mark as answered when completed.
Check your post for replies or request for more information.
Have the COURTESY to send an ending note even if the answer didn''t work.
Post by vassilisI cant find those properties ...the second form is nt embending , i made it
using the form wizard and open with a command button and i want to link it to
the main form .
Post by JamesDeckertIn the properties for the subform. The "Link Master Fields" and "Link Child
Fields" specify the link. When you create a form with a subform, the wizard
gives you the option of making the subform a popup. If you still need help,
create a new form using the wizard and go into its properties to see how to
change your original form.
James
Post by vassilisHi
i have two tables (one-to-many) and i made the second as a pop up form which
is open using a command button from the main form (first table), but i cant
find how i can declare the linking fields betwen those forms , and i dont
want to use the subform as an embending because i use it rare . So how i can
accomplish this ?
Thanks