Edit Form does not allow to update any value!

  • Thread starter Thread starter mezzanine1974
  • Start date Start date
M

mezzanine1974

In my database, I would like to make the things easier for the user to
edit row items. My target is to enable user to focus on required
invoice items quickly. The table is called "Tbl_Invoice" which is
related to other tables where all relationships are enforced for
referential integrity and all allowed for cascade update related
fields and cascade delete related rows.

I designed a query for "Tbl_Invoice" and which is bounded to a
"Form1". In that form, I provided two combo boxes: where you can
select "Purchase Order" and "Supplier Name" respectively which are two
fields of "Query1" coming from other different related tables.

So, user easily can focus on required invoice items based on selected
Purchase Order and Supplier Name.

My problem is that user can not change field value in any row on the
"Form1"

What might be the reason?

(I hope i could explain the situation successfully)
 
First check make sure you form is set to take changes under Properties -
Allow Edits.

If that is set to Yes, then try cutting the combo boxes to see if that
allows the users to enter data.

If that does not work the problem is probably in the way your relationships
are set up. Personally, I have related my way into an unusable database a
few times.

Be careful when using referential integrity and cascades. Their use implies
a consistent relationship between tables and it is hard to say from the post
if those relationships are actually there.

PJ
 
The reason for why i can not edit row items in Form1 is following
statement which i found after Rural Guy`s adviseSo, i have removed one table which is not necessary for Query1.

However, very strange, my second Form has same problem, which is bound
to another query based on very similar principle. But, I can fix the
problem by setting Recordset Type as Dynaset (Inconsistent Updates)
instead of Dynaset.

I am trying to figure out why Dynaset type is not wirking in second
Form. Anyway, i got what i need for this moment.

Thanks for your helps!
 
Back
Top