Update Not Allowed On Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've build a couple of forms utilizing queries to first gather data from
several tables and then allow the updating of that data back to the tables.
Probably a very fundemental process but relatively new to me as an Excel
junkie. Anyway, the fisrt form's query draws certain field data from 3
different tables. The second form's query draws from the same 3 tables as
well as one additional table. Both query's require user input for the key
data (key is the same for all tables).

Here's the issue: I can update the data in the first form and when I run
the query I can even add a record (blank one at the bottom). On the second
form, it won't allow me to update any data and when I look at the query it
doesn't have the blank record at the bottom. I've checked the form and query
settings and they're identical from what I see.

What am I doing wrong? Any help you can give me would be greatly
appreciated. Thnx All
 
You are creating an uneditable recordset. You can tell that by the fact you
don't get the blank record.
When using a query to join multiple tables you will often have a situation
where the joins create multiple rows for the first table because there are
multiple records in the second table that match the criteria for the first.
There are other situations that can cause this as well.

When you have a one to many relationship between your tables, it is better
to use a form/subform format.
 
Back
Top