AbsolutePosition is equal to -1

[Rob Bunocore]

I am have a continuous form as a subform which has a field called
Status. For complicated reasons, I need users to only enter a status
on the first record of the form no matter how many records there are.
I wish I could only display this control on the first line, but
can't. I put code into the control that gives the user a warning if
they try and enter a value in the is control but its not the first
record.

I'm using AbsolutePosition to determine if I'm not the first record or
not and my code seems to work. My problem is that every so often the
AbsolutePosition of the first record is calculated as
-1 and not 0.

Does anyone have any explanation for this?

Robby

[Allen Browne]

If the form opens filtered so that it contains no records, its
AbsolutePosition is -1

For example:

DoCmd.OpenForm "Form1", DataMode:=acFormAdd
? Forms!Form1.Recordset.AbsolutePosition

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Rob Bunocore" <ro**********@infocore.uswrote in message
news:11**********************@y66g2000hsf.googlegr oups.com...

>I am have a continuous form as a subform which has a field called
Status. For complicated reasons, I need users to only enter a status
on the first record of the form no matter how many records there are.
I wish I could only display this control on the first line, but
can't. I put code into the control that gives the user a warning if
they try and enter a value in the is control but its not the first
record.

I'm using AbsolutePosition to determine if I'm not the first record or
not and my code seems to work. My problem is that every so often the
AbsolutePosition of the first record is calculated as
-1 and not 0.

Does anyone have any explanation for this?

Robby