.update

  • Thread starter Thread starter JGR
  • Start date Start date
J

JGR

I have not gotten to the .edit problem yet. When it
reaches the 'Set rs= ' statment it crashes with 'Run Time
Error 424 Object Required

I have rs dim as Variant. Is this correct?


-----Original Message-----
In your code you I think you need to set the record set
Click to expand...
to the edit mode. So where you have "with rs" right under
that add .edit .That may fix your problem, it should have
given you an error telling you the record set was not in
edit mode so it could not be updated.
 
You should dimension your rs as either DAO.Recordset or an
ADODB.Recordset. This all depends on what type of data
access code you are using. Also verify that you have the
proper references selected under Tools,References menu bar
in the code module.
--Craig
 
Back
Top