Forms show in Design, but not in Live/Layout View (one form works fine though)

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!
 
Attach db so we can view.

Sounds like you haven't set up your Child and Master fields correctly on your subforms.
 
I don't have any subforms. I will try to upload a version of my DB in a few. Thanks for the quick response.
 
Let's see your db.

Edit: Sorry for my very late response. I didn't see the last two posts.
 
I have uploaded a lessened version of the database with the problem in question.

Open the frmUserID and input 0004, it will open the form and bring up the error. If you End the debugger, you'll see the blank form.
 

Attachments

Look at the Row Source of your form and check the relationships.
 
I added tables that would relate the tables for the form. I even went ahead and took out what I had in my row source for my drop-down box (although it seemed right). And in either case I still get the error and the form still displays as blank.

Do I need a relationship between the two tables for the Row Source? For all my fields? At the moment, I only have the one table that the drop-down box refers to...
 
You need a meaningful relationship between both tables. You need to read up on normalisation.
 
I created a relationship in the form after checking, but I need this for all Row Sources as well?
 
Naturally forms require row sources with well-formed tables and relationships so yes relationships need to exist in your case.
 
Just so I'm not confused, this is needed not only for the Record Source of the form, but for every Row Source of each field.

Thanks for the help! This has been driving me crazy.
 
Fields don't have Row Sources so I don't understand what you're referring to. Can you elaborate?
 
When I get the Form Properties, I only see Record Source, not Row Source. I was using fields wrong, I meant to say combobox, but that is the only time I see Row Source.
 
Sorry my bad, I've been saying Row Sources ever since when I actually meant Record Source. My brain must be fried. :confused:
 
Unfortunately, even with other tables added that have relationships with both tables, I still get a blank form. :confused:
 
I didn't mention anything about adding more tables Heatshiver. Remove all the other tables and start off with one just the one. If you want to link your tables to other tables, then you should be using a subform (if the relationship is one-to-many).
 
Wow, I feel pretty dumb right now. Thanks for the help. Worked once I got it in. Now I just need to test it with data.
 
Desbloquear la vista diseño en informe de Access 2007

hola, tengo formulario e informes en una base de datos, no hice, pero ahora no puedo modificar, la opcion de vista deseno aparece bloqueada, por favor si alguin me puede ayudar
 
Re: Desbloquear la vista diseño en informe de Access 2007

Via Google Translate;
Hi, I have form and reports in a database, I did, but now I can not change, the view option Deseño appears blocked, please if you can help me alguin
 

Users who are viewing this thread

Back
Top Bottom