this record is not updatable

N

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???
 
W

Wolfgang Kais

Hello Nawel.

Nawel said:
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???
Click to expand...

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.
 
N

Nawel

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
 
N

Nawel

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

Rick Brandt

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

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.
 
N

Nawel

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
 
Top