DMax Question

[Bill6868]

I need to have this form, that when it opens, it opens up to the highest record number [RecNo] that is in the table.

The data type of the field [RecNo] is a long integer. I'm guessing a DMax "On Open" event but not sure what to write.

Any suggestions would be most appreciated.

Bill6868

 

[dhookom]

Why not set the ORDER BY in the form's record source to sort by RecNo descending?

Duane
Hook'D on Access
MS Access MVP

 

[Bill6868]

Thanks Duane. That'll work. Much appreciated.

Bill