Heatshiver
Registered User.
- Local time
- Tomorrow, 00:27
- Joined
- Dec 23, 2011
- Messages
- 263
I have a database where I have several input forms. There are certain fields which each have, and other specific to only a few.
I just went through the process of normalizing my database, then reconnecting all the fields as needed.
My first form works flawlessly. However, when I open any of the other forms in Live or Layout view, they don't show anything. They do show is Design view.
I have checked to make sure Data Entry is set to No, and that Allow Form View and Allow Layout View are set to Yes.
I have a userID field that is all the forms. I have a preliminary form that asks for a userID, and that userID is then transferred to the forms aforementioned. However, when it tries to load one of the forms (except for the first), I get the error: "You can't assign this value to this object." This does work on the first form without problem. This leads me to believe that maybe the table cannot be updated, but I'm not sure how to change that...
Any help would be much appreciated!
I just went through the process of normalizing my database, then reconnecting all the fields as needed.
My first form works flawlessly. However, when I open any of the other forms in Live or Layout view, they don't show anything. They do show is Design view.
I have checked to make sure Data Entry is set to No, and that Allow Form View and Allow Layout View are set to Yes.
I have a userID field that is all the forms. I have a preliminary form that asks for a userID, and that userID is then transferred to the forms aforementioned. However, when it tries to load one of the forms (except for the first), I get the error: "You can't assign this value to this object." This does work on the first form without problem. This leads me to believe that maybe the table cannot be updated, but I'm not sure how to change that...
Any help would be much appreciated!