problem with bookmarks and newly created record

[xezekielx]

Hi! I have a problem (AGAIN!!)... I have a small form with a listbox that contains the names of the customers in the database. When I select a customer and click the open button, the main form refreshes and displays the information for the customer that I selected in the "open customer" form (it is a popup form). Everything works here. The problem comes when I add a new customer with a "new customer" form. When I click the 'Save' button on that form, I use the Bookmark property to "reposition" (not too sure if it's the right word but anyway) the main form to the newly created customer. Under Access 2002, everything works fine, but with Access 2000, the selected customer is the last one before the newly created customer
EXAMPLE (in case what I just said isn't clear):
1. Roger
2. Mark
3. John
4. Peter <-- NEWLY CREATED CUSTOMER
The information displayed on the main form is "John's", not "Peter's". I tried using the method

DoCmd.GoToRecord acDataForm, "frmMain", acLast

but it doesn't work either... What am I doing wrong? Thanks for any help!!

 

[gol4]

DoCmd.GoToRecord acDataForm, "frmMain", acNewRec
or save the record and it will then be the last one

 

[xezekielx]

Thanks, but I found out what was wrong... I forgot to use the Requery method on the main form after using the AddNew and Update methods on its recordset. But thanks anyway for trying to help me out! I really appreciate it!