>>>Yes I am using a data control and I'm setting its RecordSource property
>>>with an SQL. The updatable property is TRUE. Is everybody doing this?
>>>Or is it just me who is stuck!??!
>>>
>>>Thanks for the reply.
>>
>>Well, the answer to your question there is that no, not everybody does this. I do not use data controls at all. Have you tried to see what happens if you don't use a data control? I realize that this is not something that you may want to do.
>>
>>I'm not sure why it won't let you update the data. Can you post some sample code?
>
>
>Sure! Thanks a lot...
Judging from my own experience, it would seem to me that the problem is that the query you are using is not an updatable one. Usualy when there are calculated fields or bound (through a relationship) data. If indeed you are using a query stored in an Access DB, try running the query from Access and check to see if you can update the data from there.
Other than that, I'd have to check further back to other occasions when I've encountered this problem.
Hope the helps somewhat
"My get up and go must've got up and went"
-Steve Tyler, Aerosmith