Datasheet / subdatasheet

[Charles]

Having a weird issue with a datasheet which has a sub-form (a second
datasheet). When you do this Access puts a small (+) on the master form
that when clicked opens the associated child rows in the sub-datasheet.

My issue is the database insures that a relationship exists but clicking the
(+) does not always bring up a row. Sometimes you can click the row again
and it will come up.

Also Is there a event that fires when the (+) is clicked?

Thanks for any help

Charles

 

[iyad]

-----Original Message-----
Having a weird issue with a datasheet which has a sub- form (a second
datasheet). When you do this Access puts a small (+) on the master form
that when clicked opens the associated child rows in the sub-datasheet.

My issue is the database insures that a relationship exists but clicking the
(+) does not always bring up a row. Sometimes you can click the row again
and it will come up.

Also Is there a event that fires when the (+) is clicked?

Thanks for any help

Charles


Hi

make sure that you base the subform on a query,when you
do so go and check the that query and make sure that it
brings data that is supposed to be brought,if the query
works well,try to delete the subform and create another
one,then attach that subform to the main form.