the property is read only and cannot be set

[darksniperx]

Hi,



I have a sub-form for my main form. Ever since I had it set up, every time I would try to add something into the sub-form I would get the following error message `the property is read only and cannot be set`, once I hit ok, then I can enter the information and continue to work with it.

What can I do to get rid of that error message.

Thank you!

[jbarrum]

Do the two tables the forms are built from share a common field? I would go to the properties of your subform and make sure the chld link and master link fields are set to the correct and same field (The common field). It sounds like there is no relationship between the two.

[darksniperx]

Hi,

I went into subform properties, and clicked All. I dont seem to find any fields indicating, chld link and master link fields.

[jbarrum]

The best way is to open the main from in design view and then click on the subform so that you see the border around it. once you see the border around the subform then click the propeties button at the top of the screen. Look on the "data" tab and you will see the two fields I am talking about. They are called "Link Child Fields" and "Link Master Fields"

let me know if you are still having trouble

[darksniperx]

Hi I have just checked, link master and child fields are correctly configures.

It displays the data correctly, it just I get this error at the first entry.

[jbarrum]

I am not sure then. if you do not have any sensitive data in the DB the you can post the DB and I will take a look. Otherwise, I am at a loss. You can always try deleting the subform and then recreating it.

[jbarrum]

are you using any reserved words as a field name. Using reserved words in access as field names can cause this problem. Follow this link a a reference to reserved words in access:

http://www.databasedev.co.uk/ms-acce...ved-words.html

[darksniperx]

Here is a simplified version of the database.

Click on forms,

student registration,
click nouvelle instription.
set 1 for first name and last name
Click on activity type textbox, and press `a`
Thats when the error will show up.

[jbarrum]

When I look at the properties of the subform I see the "data entry" set to "NO" change this to "YES" and then try it again.

[darksniperx]

hi,

just tried that, no change.

[jbarrum]

I do see a field name in one of your tables called "name" You might want to try changing this to name_id since it is a place holder for the persons ID number. This word is reserved in Access and my be causing your problem. Also, I do not see any relationship between the two tables. Usually the form and main form will be linked by a field storing the same data so the will have the same data type. when I look at what links your forms,it is "name" in one table which is a text field) versus studentID in the other table (which is a numberic field). This two forms should be linked by fields with the same data type.

[darksniperx]

Hi,

StudentId and Name field are the same fields. It has been a while since I created subform. I will rename it back to studentId. and see if it changes anything.

thx.

[jbarrum]

No problem. let me know if that works. If not I will try something with your db and send it back to you.

[darksniperx]

It seemed that the issue is fixed, I will need some time to make sure it will not appear again and implement the fix on the actual program.



Edit:
Seems ok so far, local test went good.

[jbarrum]

great, let me know if ther is any more trouble