By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,340 Members | 1,988 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,340 IT Pros & Developers. It's quick & easy.

recordsets?

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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.

Nov 13 '05 #3

P: n/a
the relationships are
TblListedItems to TblSold - Indeterminate
TblSold to TblPacking - 1 to 1

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.