mcdhappy80
Registered User.
- Local time
- Today, 01:41
- Joined
- Jun 22, 2009
- Messages
- 347
I have changed record source of a form from single table to a query that joins two tables.
I also had to set Cascade Updates in the relationship between the two tables in order to be able to edit the PK field on a form.
After these changes, when I try and edit PK field from form I'm getting this message (atached).
Is there a way to turn this message off or somehow change it?
In my current situation it's not event true, because I'm the only user at the moment trying to change the record.
My application will, however, be working in multiuser environment so maybe some time this conflict could appear, and maybe I would need a way to process it and inform the user(s) instead of turning it off. Can someone share a thought on this case?
I've done some reading since posting this message, and regarding what I have read, I have to say, that I've set form's record lock property to edit record, and now I'm getting error message "3218 - Could not update. Currently locked".
Does this have to do something with the query as forms record source? It's confusing because I'm the only one opening one form and trying to edit record.
How can I see who (what) is locking this record beside me?
Thank You.
I also had to set Cascade Updates in the relationship between the two tables in order to be able to edit the PK field on a form.
After these changes, when I try and edit PK field from form I'm getting this message (atached).
Is there a way to turn this message off or somehow change it?
In my current situation it's not event true, because I'm the only user at the moment trying to change the record.
My application will, however, be working in multiuser environment so maybe some time this conflict could appear, and maybe I would need a way to process it and inform the user(s) instead of turning it off. Can someone share a thought on this case?
I've done some reading since posting this message, and regarding what I have read, I have to say, that I've set form's record lock property to edit record, and now I'm getting error message "3218 - Could not update. Currently locked".
Does this have to do something with the query as forms record source? It's confusing because I'm the only one opening one form and trying to edit record.
How can I see who (what) is locking this record beside me?
Thank You.
Attachments
Last edited: