Can't enter data into my form

[Zak14]

I was able to enter data into my form but I made a few design tweaks and added another table into the form and now, in form view, I''m unable to enter data into any field.

I think this link might be the solution to my problem, but I don't know what they guy is talking about. It'd be great if this could be translated into noob language.
answers.microsoft.com/en-us/office/forum/office_2003-access/cant-enter-data-into-an-acces-form-but-can-enter/b6b14e36-2f10-4440-a74a-4c07ae849d4d

Thank you.

 

[plog]

...and added another table into the form...

You probably created an unupdateable query. A form that allows you to modify data should have it's control source as a table, not a query. Doing that will ensure your form works properly.

1 form, 1 table. Queries shouldn't be the basis of a form you intend to use to modify data.

 

[Zak14]

You probably created an unupdateable query. A form that allows you to modify data should have it's control source as a table, not a query. Doing that will ensure your form works properly.

1 form, 1 table. Queries shouldn't be the basis of a form you intend to use to modify data.

I didn't base it off a query; I don't have any queries in this database yet. The form is based on 3 related tables.

 

[plog]

"based on" is sort of ambigous, let's get technical. A form can only have one Control Source. What is the control source for the form in question? Is that control source a table? If so, you should be able to update every input that has a bound field on the form.

Also, what do you mean when you say "based on"

 

[Zak14]

"based on" is sort of ambigous, let's get technical. A form can only have one Control Source. What is the control source for the form in question? Is that control source a table? If so, you should be able to update every input that has a bound field on the form.

Also, what do you mean when you say "based on"

Well, not "based on", sorry. I mean the form "includes" 3 tables.
And how do you check and edit the control source of the form? (idk how to)

Please also see the link I put in my first post. That might be my solution; only idk how to do what it says on the answer.

 

[plog]

I misspoke, for a form it is called Record Source. To find out what your form's Record Source is do this:

Open the form in design view
Click on 'Property Sheet' in the ribbon
the top entry on the 'Data' tab will show what the Record Source is

 

[Zak14]

I misspoke, for a form it is called Record Source. To find out what your form's Record Source is do this:

Open the form in design view
Click on 'Property Sheet' in the ribbon
the top entry on the 'Data' tab will show what the Record Source is

Ok, I see what the record source is. It says SELECT then the name of the (main) table I used to create the form.
But how do I solve my problem though?

 

[Zak14]

Anyone know why I can't enter data into my form?

 

[plog]

Can you post your database?

 

[vbaInet]

Anyone know why I can't enter data into my form?

Please exercise some patience. Plog is onto something and he's trying to get the bottom of the problem.

Without us seeing your db, the easiest solution is to recreate the form with only 1 table. You could have changed a setting or made an inappropriate link that's not allowing you to make any updates via the form.

 

[GinaWhipp]

Zak14,

Please post the Record SOurce of your Form. So, where you saw the word SELECT (from post # 7), copy that entire line and post here. Most likely there is something in that line that is preventing you from entering data in your Form.

 

[Zak14]

I've solved the problem!
Thank you everyone who answered.

FOR FUTURE VIEWERS:

The reason I couldn't enter data into my form is because the 3 tables were related using the one-to-many relationship.
It's fine like this with 2 tables because Access can just show multiple records for 1 primary key. For example, let's assume Table 1 has the primary key and Table 2 and 3 have a foreign key. If the form includes only 2 tables, the form can show many records from Table 2 for 1 record in Table 1.
However, when 3 tables are invloved, Access doesn't know which record from Table 3 should link to Table 2 (even if there is only 1 record in Table 2 per record in Table 1).
I'd guess that only 1 table can have the one-to-many relationship; the rest must be one-to-one.

SOLUTION: Change the relationships from one-to-many to one-to-one. So the tables with the foreign key should have a one-to-one relationship with the table with the Primary key.
To do this, open each table with the foreign key (i.e. Table 2 and 3 in our example) in design view. Click on the foreign keys (the keys that are linked to the primary key in Table 1) and under 'Field Properties' set the 'Indexed' option to "Yes (No Duplicates)".
Click here to see more on creating a one-to-one relationship.