My new record going first record instead to the last record

juniepiper27

Registered User.
Local time
Today, 13:14
Joined
Sep 24, 2014
Messages
49
Hi!
I just wanna ask if I going to add new record in my database... the new record going to the first record instead of last record. can you tell me why this happened and give me a solution...

Thanks you so much & more power..

Thanks,
 
There are several ways, one is:
Code:
DoCmd.OpenForm "YourFormName", , , , acFormAdd
 
There is no inherent "first" or "last" - it's like a bucketful of fish slithering around (using Bob Larson's analogy) .

You want a specific order you have to sort the data accordingly - specify sort in the queiry used as data source. Or in the approprotiate form property - check out the form's properties.
 
Sir,

my problem was the new record that I input was going to the first record. instead of last record. I want that my new record I input will go to the last record not in the first record...

Please help me..

Thanks
 
No I dont want to sort my record in a query... I want just a normal inputting of a record. I want that my new record I input will go to the last record not in the first record.

thanks,
 
No I dont want to sort my record in a query...

You can want all you like but it won't help. There is no way to control where the records are placed in a table. That is how Access works.

If you want to see them in a particular order you have to order them in a query or on the form or report.
 
ok Thanks to all of you... I know the reason... when I try not to have a primary key.. the record what I want is working... but its difficult to remove the primary key because my database is linking by a asset number which is the primary key... you right sir.. this is the rules of access we can do nothing for that..

by the way sir, can you answer my thread yesterday...? the title is "How to open a report from filtered subformquery" please sir, I want that what ever I filtered in a subformquery will display in my report.. pleas try to help me..

Thank you so much for your support
 

Users who are viewing this thread

Back
Top Bottom