update query

[Guest]

Sometimes, I cannot add a new record (in general update) to a query and/or
form that link to that query. (It takes the values two different tables).
What can be the reason. How can I add a new record.

 

[Michel Walsh]

Hi,


Can be many reasons. If the problem occur only "some times", meaning
that it work "in the other times", then it is probably either a validation
rule of a field ( a value is required but not supplied, a value >= 0 is
required, but negative, etc. ) a validate of the record (like if you imposed
that endingTime >= startingTime in the table design, and the actual value do
not pass the test), or a referential integrity rule (like a parent-child
relation where the parent must be already known in table of parents, before
using it in the junction table of parentsAndChildren).


Hoping it may help,
Vanderghast, Access MVP