updating subform in datasheet/Continuous view

[Avizan05]

hi,

I m having a subform in datasheet view. whn i use a join query as the record source for the sub form, i am not able to add or update any record in the datasheet.
Is there anyway to use a linked query as record source of the datasheet with editable property.

 

[spikepl]

http://allenbrowne.com/ser-61.html

 

[Avizan05]

Thanks spikepl...
the join query i am using is
("SELECT A.Job_no, A.Cmp_ID, A.cmp_op_id, A.Group_Code, A.Complaint_type, A.Tech_ID, A.Warranty_Req,A.lab_cost, A.Mask, A.Tech_tab, " _
& " B.lab_hr FROM Cmp_list A left join " & [TempVars]![modelcode] & " B on A.cmp_op_id = B.op_id " _
& "WHERE A.Job_no =[TempVars]![jobid] AND A.Mask =False")

i have indexed A.cmp_op_id & B.op_id and they are unique identifiers.
If i define the relationship of the tables A & B as left join will i be able to edit the resultant datashet view??