AshikHusein
Registered User.
- Local time
- Today, 00:44
- Joined
- Feb 7, 2003
- Messages
- 147
I am having problems editing info from a specific field on a form.
The basic outlay of the structure is as follows:
There are two tables linked by a field called IPO_name. (say Table1 is the primary table and Table2 is the linked table). Referential integrity has been set along with cascaded updates, and deletes.
The form used for the purpose has the "IPO_name" field bound to Table1 and all other fields bound to table2.
The required record is selected through an unbound combo-box with its source as "IPO_name" from table1. When a certain IPO is selected through the combo-box, I use VBA to display the relevant record by the recordsetclone method and the bookmarks method, which works fine.
The problem is that when I try to change the name of the IPO in the IPO_name bound field on the form, I get an error saying that the current record is locked and the changes therefore cannot be updated. I do the similar thing with another form in which the fields on the form are not frawn form linked tables, and it works fine there. Could anybody help me with an insight into this matter? Thanks.
Ashik
The basic outlay of the structure is as follows:
There are two tables linked by a field called IPO_name. (say Table1 is the primary table and Table2 is the linked table). Referential integrity has been set along with cascaded updates, and deletes.
The form used for the purpose has the "IPO_name" field bound to Table1 and all other fields bound to table2.
The required record is selected through an unbound combo-box with its source as "IPO_name" from table1. When a certain IPO is selected through the combo-box, I use VBA to display the relevant record by the recordsetclone method and the bookmarks method, which works fine.
The problem is that when I try to change the name of the IPO in the IPO_name bound field on the form, I get an error saying that the current record is locked and the changes therefore cannot be updated. I do the similar thing with another form in which the fields on the form are not frawn form linked tables, and it works fine there. Could anybody help me with an insight into this matter? Thanks.
Ashik
