recordsets?

[gbb0330]

Hi all
i need some help again

i have a form
based on a recordset

Private Sub Form_Load()

Me.RecordSource = "SELECT TblSold.SeBayNUM, TblSold.SnoteTXT,
TblSold.SQ0NUM,TblSold.SQ1NUM, TblSold.SQ2NUM, TblSold.SQ3NUM,
TblSold.SQ4NUM,TblSold.SQ5NUM, TblSold.Ssold, TblSold.[Sold Key],
TblListedItems.LeBayDescriptionTXT, TblListedItems.LL0TXT,
TblListedItems.LL1TXT, TblListedItems.LL2TXT, TblListedItems.LL3TXT,
TblListedItems.LL4TXT, TblListedItems.LL5TXT FROM TblListedItems INNER
JOIN TblSold ON TblListedItems.LeBayNUM=TblSold.SeBayNUM WHERE
(((TblSold.Ssold)=True) AND ((TblSold.Spacked)=False));"

End Sub

once the form opens i want ot be able to change the value of
tblSold.Spacked to True

any ideas of how to do that

[gbb0330]

if i remove all the fields from TblListedItems everything works fine,
but then i Cant get the values of LeBayNUM and LLTXT 0 to 5 to appear

[pietlinden]

If you're trying to modify the records on the ONE side in a one-many
relationship, I don't think you can - well, not the way you're doing
it. You could put the records on the MANY side into a subform and do
it, though.

[gbb0330]

the relationships are
TblListedItems to TblSold - Indeterminate
TblSold to TblPacking - 1 to 1