Display a control in the last record of a continuous subform?

[Andrew]

Hi all

A quick question which I've not been able to solve from trawling the
web.

Is it possible to have a control in the detail section of a form set
to a default view of "Continuous" which only appears on the last
record?

I'm thinking of having a form with a subform, and would like the
subform to list related records, but have a "+" button to allow adding
a new record. I know I could put it in the form footer, but that can
be quite a way away from the data, if there are only one or two
records showing, so I wondered if there's a way of controlling the
visible property with (presumably) some reference to the current
record's position within the recordset. And which event would need to
trigger this code?

Thanks in advance.

Regards
Andrew

 

[Arvin Meyer [MVP]]

Consider either putting it in the subform header directly under a set of
labels; or using 2 subforms, preferably the last record one as a read only
so there can be no page locking conflict.

 

[Andrew]

Consider either putting it in the subform header directly under a set of
labels; or using 2 subforms, preferably the last record one as a read only
so there can be no page locking conflict.
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com











- Show quoted text -

Hmmm.. Okay, Thanks.

On a related issue, is there a way of having controls visible or not
on a continuous subform based on whether a field value for that record
is null?

Thanks again

Andrew

 

[Arvin Meyer [MVP]]

On a related issue, is there a way of having controls visible or not
on a continuous subform based on whether a field value for that record
is null?

You can change formatting conditionally on a continuous form (starting with
Access 2000) but not the properties, like the Visible property. For
conditional formatting, open the form in design view and choose it from the
format menu.