I have a three form(1 main 2 subforms) DB. This is a shared database with the tables on a main computer and everyone has the forms along with autoupdating. We fix computers here and there is a list of unworked on or unfinished computers so we can keep track of what all needs to be worked on still. so we dont forget about one like we have in the past.

There is a queried list on the main form that every 10 seconds or so will save and requery. This way if there is a change it will appear on everyones screen ( cool eh) it works lie a charm. I then have a click event to open the forms of that individual. This works as well.

However when one computer on the network adds a new computer, it shows up on the list like its suppose to, but when any other computer clicks on that newly added computer, it brings up the form with the very first record in the customer table instead of the newly added customer. I have to close down the database then reopen it, at tat point it shows the correct information.

each table has a primary key for the ID and is autonumber obviously.( I didnt have one in the subsubfrm table but I just added it)

any ideas, any clarification??