Checking BOF and EOF in a form?

[RageMatrix]

Hey all,

I'm just wondering if its possible to detect in a form whether the current record is the first or last record in the query/table. I want to disable the Previous or Next Record buttons if this is the case. Perhaps there is something that Access has like a recordset object, so that you could check the BOF and EOF flags. Can this be done with Access?

Thanks

Jon.

 

[TonyJollans]

Hi RageMatrix,

In your form code you should be able to refer to Me.Recordset and use its properties and methods just like any other recordset.

Enjoy,
Tony