subforms in datasheets.

[Martin Scott]

I want to pick up the expanded value of a subform in a datasheet. In the first column of the data sheet it displays a + and when the form is expanded it show a -. I sure there's and event that I can pick up for this as well.

Any clues?

Many thanks

 

[Larry Linson]

I want to pick up the expanded value of
a subform in a datasheet. In the first column
of the data sheet it displays a + and when
the form is expanded it show a -. I sure
there's and event that I can pick up for this
as well.

Datasheets do not have events. (Nor do they have subforms; they have
subdatasheets.) I suspect the reason they do not have events is that the
developers of Access intended them for end users, not really as a part of a
developed application that needed "programming". Forms have events and
provide that control. Continuous view forms allow you to see multiple rows
and columns, and they have events, as well.

Larry Linson
Microsoft Access MVP

 

[Martin Scott]

Ah!... found it in VBA help after looking for 'subdatasheet'.

I needed to create a property to show when it was expanded. The
subdatasheets are very odd... but I've got my head round them now.

Thanks anyway,

M.