WHY CAN'T I UPDATE MY TABLE WITH A QUERY

[chubby]

I have a little problem thats just killing me. I can't update my tables with a query!!

1. I have three tables linked by SSN
a. Master personnel tbl
b. Med 32253
c. PRT 32253

2. I have a query taking info from all the three tables.
Master personnel tbl Full name, DOB, GENDER
Med 32253 tbl HT, WT, BF%
PRT 32253 tbl RUN times, swim times, over score

3. I have a form with the above query as the underlining
source so my end User can update this information from
one form.

But Access won't let me add/change or update any of the information in any of the tables thur the use of the form.
WHY is that? How can fix that??

 

[tomschafer]

When using an SQL as the Record Source for a form the Recordset flavor is snapshot. Thus you can't update it. Try using a form with all unbound controls and then have your update query select those controls...

update
TableName
set
FieldName1=Forms!FormName!ControlName1,
FiledName2=Forms!FormName!ControlName2

 

[montrose]

chubby, Also check out Help, type in "query", then look at "ways to bring together data from multiple tables etc.", then click for more information about "When can I update data from a query". Either use Pezamystik's approach, or a form/subforms approach. HTH, Montrose Learn what you can and share what you know.