Dec 10 2007, 06:19 AM
I don't know what I did but the values on the sub forms can't be changed. Some of the values are in the combo box, text boxes and so on. I can only see it but it can't be change or typed in...
Can someone advise me what i did wrong?
Dec 10 2007, 06:23 AM
It may be the recordset of the subform is not unpdateable and the problem will be in your relationships between the underlying tables of the subform..
Is the subform based on a query..?
Dec 10 2007, 08:21 AM
yes,it is based on a query. I see , the lock on the form is set to No. All all the records tabs are set to editable, deletable and so on?
Dec 10 2007, 08:30 AM
When you try to change/enter a value do you get a error message at the bottom left hand corner suggesting the record is not updateable..?
Dec 10 2007, 09:19 AM
No. Just that I can't type anything in. The cursor wouldn't move. Not only that i can't delete. Basically it seem to me that all the controls are locked???
Dec 10 2007, 09:44 AM
Are you able to post the db..??
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here