SQL based form determine last record 2

[tigersden]

Hi,
Is there anyway to determine when you are at the last record of a form based on a SQL query?

 

[gol4]

If you want to return the first or last record in a set of records (a domain), you should create a query sorted as either ascending or descending and set the TopValues property to 1.

docmd.gotorecord,,aclast

is the easiest way

or bookmark

 

[PHV]

A starting point:
With Me.Recordset
If (.AbsolutePosition + 1) >= .RecordCount Then
MsgBox "You're at last record"
End If
End With

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tigersden]

Hi gol4,
Thanks for the info, what I was trying to do was stop the form moving to a new record.
The form is purely used for editing or reviewing existing data.

Tim

 

[PHV]

Set the AllowAdditions property to False

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[gol4]

Phvs suggestion is another option
just set the forms allowadditions property to false

 

[tigersden]

Thanks both!!