On Tue, 25 Jul 2006 04:30:02 -0700, row insertion
>please help it's very urgent
I see you're getting some answers, but your question isn't very clear.
What is the structure of your table?
What are you trying to accomplish? I'm GUESSING - as some other
respondents have - that you're thinking of a table as if it were a
spreadsheet (it's NOT), and that you're trying to insert a record at a
particular row in the middle of a table.
Tables don't work that way. A Table is best viewed as an unordered
"heap" of records. If you want to see records in a particular order
you must - no option!!! - use a Query sorting the records into that
order. You can add a new record to the end of the table, and (if
necessary) requery the Form on which you're displaying the data (usingReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13868
a Query on the table), and it will re-sort the records moving the new
record to its appropriate location.
If I'm misunderstanding your subject line - please post some usefulReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13868
details (rather than just a plea) in the text area.
John W. Vinson[MVP]