Insert a row into a data sheet

[Brian]

I would like to insert a row into an existing datasheet..
not at the end, or the beginning. I have follwed the
instructions in the help menu; however, it did not work. I
right clicked on the row header itself, and the closest
option was to click on the -new record- icon, but that's
not what I need to do.

 

[Cheryl Fischer]

Brian,

This cannot be done. To quote Access MVP, an Access table is "an unordered
'bag' of data". If you want to control the position in which a record is
displayed, then you will need to set indexes or create a query in which the
data is sorted by one or more fields.

 

[Cheryl Fischer]

Providing correct attribution for that quote: it is from Access MVP John
Vinson.