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

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, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Andrew" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

On Jul 12, 3:17 pm, "Arvin Meyer [MVP]" <a...@m.com> wrote:
> 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
>
> "Andrew" <andrewmricha...@yahoo.co.uk> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> > 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- Hide quoted text -
>
> - 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

"Andrew" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> 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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com