Fill Record with Data from Previous Record Automatically

[Marie]

Using Office 2000. I am trying to us Knowledge Base
article 210236 to fill record with data from previous
record. The fields I am trying to fill
are: "fldCompanyNum;fldSamSize;fldAccManNum;fldAction;fldAc
tionDate;fldSampleSource;fldNotes"
I cut and pasted the code for the Knowledge Base artcle.
Was there anything in the code (except the field names in
the text box added to the form) that needed to be named
specific to my database. When I try to add a new record to
the database, "RS As DAO.Recordset" is highlighted in the
code, and I get the following error: User-defined type not
defined." What am I doing wrong?

Thanks for the help.

Marie

 

[Drew]

you need the DAO 3.6 Reference. Also, just in case you
have the reference, make sure you are using one of the
three needed words..... Dim .... Private.... Public...
before RS AS DAO.Recordset

Are you getting intellisense, or did you simply cut and
paste??

Drew

 

[Marie]

Drew,

Thanks so much for helping. What is intellisense. And how
do I "install" DAO 3.6. I thought it would be under
references, but it wasn't listed.

Marie

 

[Marie]

I figured it out. I didn't know to look under Microsoft
DAO...

Thanks.

Marie