this record is not updatable

[Guest]

hello every body,
I create a field in a table and then on a form when I want to fill it with
data I can't, the field still empty. Can you tell me Why???

 

[Wolfgang Kais]

Hello Nawel.

hello every body,
I create a field in a table and then on a form when I want to fill it
with data I can't, the field still empty. Can you tell me Why???

No, I can't.
Maybe you haven't bound the control to the field.
Or have you a validation rule that reads "Is Null"?
You have to tell us more about what you did.

 

[Guest]

Thanks Wolggang for your answer, it is just a field from a table I used in a
form, the field is bound to it, this form is also using a query related to an
other table.
Regards
Nawel

 

[Rick Brandt]

Thanks Wolggang for your answer, it is just a field from a table I
used in a form, the field is bound to it, this form is also using a
query related to an other table.
Regards
Nawel

There you go. See if the query is editable. Many are not.

 

[Guest]

"Where can I check it ??? did I need to create a relation with the table and
the query or what?? I'm really lost ???

 

[Rick Brandt]

"Where can I check it ??? did I need to create a relation with the
table and the query or what?? I'm really lost ???

Open the query by clicking the build button [...] to the right of the
RecordSource property in the form and then switch to datasheet view and see
if you can change data there.

Read the help topic "When can I update data in a query?" Some queries
simply do not allow edits as a result of how they are structured. Simple
SELECT queries usually are, but when they include multiple tables they often
won't allow edits unless certain rules are followed.

 

[Guest]

thanks for all the info, I checked my query in datasheet view and I can't
change the field content, I see also the help and it is specified there that
when it is in the same in one relation we can update ??? because I'm using
the query calculation in one form related to one table.
thanks for helping