Ok... here's my situation.
I have an mdb with my data on our server. I may have up to at least 10 users updating the data on that mdb.
For whatever reason, management wants this thing to go in one direction, so what I have is a button to go to the next record when the editing is done.
What I want to do is have my "Updated" flag updated on entry into the record, and have the other users' front-ends see that and not grab the record I'm working on.
I'm assuming that I need to do something like "Me.updated = 1", and some kind of save & requery on each next or each entry into the form, to make sure I don't grab anyone else's records.
Can someone give me some pointers as to what events and functions I should use?
Thanks,
Mark
I have an mdb with my data on our server. I may have up to at least 10 users updating the data on that mdb.
For whatever reason, management wants this thing to go in one direction, so what I have is a button to go to the next record when the editing is done.
What I want to do is have my "Updated" flag updated on entry into the record, and have the other users' front-ends see that and not grab the record I'm working on.
I'm assuming that I need to do something like "Me.updated = 1", and some kind of save & requery on each next or each entry into the form, to make sure I don't grab anyone else's records.
Can someone give me some pointers as to what events and functions I should use?
Thanks,
Mark