displaying a table on a form so that we can insert a new record at any place rather that at the end

  • Thread starter Thread starter ravindar thati
  • Start date Start date
R

ravindar thati

how can i display the table on a form so that the user is able to
insert a new record not only in the last, but also in any place of his
desire. he must be able to insert a new record even before the first
record.
how can i accomplish this?
can any body help me out please........
 
hi Ravindar,

ravindar said:
how can i display the table on a form so that the user is able to
insert a new record not only in the last, but also in any place of his
desire. he must be able to insert a new record even before the first
record.
Click to expand...
Tables in Access (in a database) are a different thing than tables in
Excel.
There is no such thing as a record position per se. You can only sort
the records by any field or combination of fields to get your desired order.

So use a data source like

SELECT *
FROM [YourTable]
ORDER BY [Field1], [FieldN] ASC|DESC

for your form and requery the form after inserting a new recordset.



mfG
--> stefan <--
 
how can i display the table on a form so that the user is able to
insert a new record not only in the last, but also in any place of his
desire. he must be able to insert a new record even before the first
record.
how can i accomplish this?
can any body help me out please........
Click to expand...

A Table is an unordered "bag" of data. There is *no such thing* as the "first
record" or "last record" or "31st record", in any useful way.

If you want to see the data in a particular order, you must include some field
or fields which define the order, and base your form on a Query sorting
appropriately.

John W. Vinson [MVP]
 
Back
Top