here is what i am trying to do. i have a form showing one user record at a time. part of this user record relates it to another user. i would like to be able to click a button and go to the record that is related. i thought maybe i could use bookmark to do this? here is the code i am putting in my onclick event:
findfirst will find the first record in the clone based on the underlying table/query which may may have a different sort order than the form does. remember it is the first record dao.ado finds meeting the criteria you specify
thank you. when i tried it again later, it was actually working, because there is only one record that will apply in any case. however the code only worked when i exited out of the form and then tried again. i am guessing this means i need to requery first or something... can someone tell me how to do that?