Shared db - can goto new record

[djayam]

Hi all,

I have a split Access2007 db with ACCDE front-end. With one user all is good. With 2 users it's almost all good...I wonder if you can help with this scenario:

Both users create a new record at the same time. The db assigns IDs OK and both records create OK. There is a combo box on the main form that shows all records and moves to the record selected AfterUpdate. The combo box is set to requery OnEnter. Each user can SEE the record created by the other in the combo box - all good! However, when they select eachother's new record they are not taken to it. They are instead taken to the last record created before the ACCDE was opened. They can then return to their OWN newly created record however.

If both users exit the ACCDE then open it again, they can now navigate to all the new records...??

Any ideas?

Thanks,

Jason

 

[djayam]

The title of this post should be CAN'T goto new record.

Sorry!

 

[djayam]

Fixed it. I needed to Requery the main form to get all db changes by other users updated. I thought as the Autonumber field was incrementing without error that I didn't need to do this.

Cheers.