hi im trying to do a form where the first subform has a relation to the main form throgh a client id. however i have been recently asked to add some extra info in such a way that it is not in the first subform but in the main form or another subform.

this new subform is more related to the first subform through a statement id and not really the main form (which is client id...hope this makes sense) because the records in this new subform should be specific to the statement id in the first subform. the problem im having is how do i make the second subform in such a way that when i click on particular row in subform 1 the corresponding row in subform two should be selected.prefereably subfiorm two should be showing only a single row rather than a data sheet style which is in appropriate.

to give you a better idea there is a good example in northwind database. look at the customer order form you can see that when you click on a record in the first subform the second subform changes accordingly, this is the sort of thing i am looking for! but i cant understnad why mine doesnt seem to work like it.

[This message has been edited by madrav72 (edited 12-08-2001).]