I've created some forms and subforms, and everytime I try to enter anything in the subform (in any field) I get the message "property is read-only and can't be set". I have done this before with other dbs and have not gotten this error. I get another error when I try to close the form "Index or primary key cannot contain a null value"...Please Help!
Need Help: This property is read-only and can't be set
- Thread starter Stefanie
- Start date
Maybe I should explain what forms I am talking about 
I just created this DB today. The Leads table is the main table. In the main form in you click "Enter Additional Patient/Lead Info, it will bring you to the form frmEnterName. The name is grabbed from the Leads table and then clicking on one of the 3 buttons will open a form with a subform. None of the subforms seem to be grabbing from the other tables...
I just created this DB today. The Leads table is the main table. In the main form in you click "Enter Additional Patient/Lead Info, it will bring you to the form frmEnterName. The name is grabbed from the Leads table and then clicking on one of the 3 buttons will open a form with a subform. None of the subforms seem to be grabbing from the other tables...
boblarson
Smeghead
- Local time
- Today, 02:07
- Joined
- Jan 12, 2001
- Messages
- 32,053
Yep, using Access reserved words and/or special characters (other than underscores) in field, or object, names is definitely something to avoid as it will bite you at some point.
Here's a good reference:
http://www.databasedev.co.uk/ms-access-reserved-words.html
