Problem with Data Entry on a Form

[Johnny Drama]

Hello all,

Here's my issue. I have a form with the data source being a query composed of data from 3 different tables.

When I go to enter data in the form I get the default "ding" noise and I cannot enter any data. All of the fields I'm trying to enter the data in are unlocked and the form is set to accept data entry.

Any thoughts?

 

[MSAccessRookie]

Hello all,

Here's my issue. I have a form with the data source being a query composed of data from 3 different tables.

When I go to enter data in the form I get the default "ding" noise and I cannot enter any data. All of the fields I'm trying to enter the data in are unlocked and the form is set to accept data entry.

Any thoughts?

You say the query is "composed of data from 3 different tables".

• Are there ANY columns from ANY of the tables that are required by the table and not included in the query? A query will be READ-ONLY unless it updates AT LEAST all of the required columns of all of the tables that it Reads/Writes data From/To.

 

[pbaldy]

Here are some additional thoughts on why the query might be read only:

http://allenbrowne.com/ser-61.html

http://support.microsoft.com/default.aspx?scid=kb;en-us;328828

 

[Johnny Drama]

The link to MS helped me figure it out...one of the tables in the query was not joined to another table. Now I have a different problem with the way the query is pulling info because of the join. I'll see if I can figure that one out.

Thanks for the help.