Insert a new record

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

I have a table opened in datasheet view in a subform. Is
there a way to insert a new record at a specific place
that is not the end of the file. All I can see is where
you can add a new record the end of the records but it
would be much more functional for the user if they have
the ability to put the cursor on a specific record and
click a button that runs a function to insert a that spot.

Thank you for your help.

Steven
 
Steven said:
I have a table opened in datasheet view in a subform. Is
there a way to insert a new record at a specific place
that is not the end of the file. All I can see is where
you can add a new record the end of the records but it
would be much more functional for the user if they have
the ability to put the cursor on a specific record and
click a button that runs a function to insert a that spot.
Click to expand...

A database table is just a "bag o' data". There is no order even though
there might appear to be one when you open the table. The only way to
ensure that you see or process records in a particular order is to use a
query that has an ORDER BY clause or impose a sort order using a form or
report.

Where the interface appears to insert new records is irrelevant.
 
Back
Top