Data sheet forms

[calobo]

Hi,



I have two tables in access, one named TblSub and the other TblDev.
The TblSub has two fields, subject and the Id which is the primary key.
The TblDev has several fields, such as time and results etc, regarding the development of a certain subject. This table is conected to the TblSub by the Id of the TblSub.

Based on these two tables, I created two separate forms on the data sheet view, one for each table.

What I want to do is to be able to have both data sheet forms open simultaneously, but not one as a subform of the other, and as I select a certain subject of the Subject form, the corresponding Developments on the other data sheet form appears.

Can anyone please tell me how this can be done

Using data sheet forms, I only know how to do this making one a subform of the other, but what I really want is for both tables to appear at the same time, but individually and sincronized by the Id of the TblSub.

Thank you for any help

Best wishes

Carlos

[pbaldy]

You could use the current event of the first form to either set the record source or filter property of the second. I'd probably set the record source.