well, this isn't an MS Access board, so I probably shouldn't, but...
It depends how you are accessing the records. Are you actually coding a sql statement in VBA? if so, you can use the same ansi SQL code you would use in MySQL - i.e. the LIMIT command.
If you are trying to limit the records from a simple filter, I'm not sure that can be done. If you are building a query, then you can build it as you normally would (in the GUI) then switch to SQL view and add the LIMIT command.
