what the ##$$$$$$@@!! am i not see or doing wrong??

[Synergy.ron@gmail.com]

rs.Editrs.MoveFirst
rs.Fields![serialnum] = s3          'WRITE SERIAL TO RS ,<<<<error

rs.Update

i even copied this code (working cop to this location and it does not work? i am sure the fault lies with my failure to see/understand some syntax rule but i can not see it. help???thanks....


Attachment 45929

[Micron]

If you want to update a recordset you have to tell Access of your intentions first.
Try rs.Edit before trying to set a field to s3

[kd2017]

rs.movefirst
rs.edit
rs!serialnum = s3
rs.update

[Synergy.ron@gmail.com]

Attachment 45934

Sory, rs.edit was omitted from the copied code. But it doesn't make a difference?????? I appreciate your thoughts. thanks.

[Micron]

You might get more focused help if you
a) posted more of the code - maybe even the whole procedure or at least what's relevant to what you are showing
b) posted code (which is easier for you) and not pictures of it.

With respect to a) I'll say I'm wondering why you have
rs.Editrs.MoveFirst and not rs.MoveFirst

Can't say I've ever seen or have invoked a recordset move using that sort of reference. Maybe if the rest/more of the code was visible it would be more intuitive.

[Synergy.ron@gmail.com]

Yes, this code required movefirst before edit. elsewhere it can come afterwords. why??? oh well, another lesson learned. Thanks for the help!

[kd2017]

Moving *after* opening for edit doesn't make sense. I'd say the code you have that elsewhere is ...wrong? It might be working sometimes but as you've discovered it might cause you problems, I'd switch em if I were you.