.addnew works in A2003, not in A2000

[Guest]

I added functionality to an A2000 mdb linked to SQL Server, to create
record/row copies from current form row. It works fine in my A2003 version,
but when tried in their A2000, it's not working.

Code is as follows..

With Me.RecordsetClone
.AddNew
![Patient#] = Me.[Patient#]
![Clinician#] = Me.[Clinician#]
![FeeStatus#] = Me.[FeeStatus#]
.....etc.......

In A2000 debug mode, looking at Me.Patient# or any of the form fields, show
null values. In my A2003, the fields show correctly as valued from copied
record.
I'm using SQL Express - them sql 2000.

I've set references to ADO lib, DAO lib, etc in their A2000.

Any ideas as to why not working in A2000 hugely appreciated.

Thanks!
Don

 

[Douglas J. Steele]

Off the top of my head, I can't think of what it shouldn't be working.

Are you getting any error message?

 

[Guest]

There's no error messages..just adds a null record when use A2000. Debug mode
I can see the null field values after the .Addnew statement.

Off the top of my head, I can't think of what it shouldn't be working.

Are you getting any error message?


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I added functionality to an A2000 mdb linked to SQL Server, to create
record/row copies from current form row. It works fine in my A2003
version,
but when tried in their A2000, it's not working.

Code is as follows..

With Me.RecordsetClone
.AddNew
![Patient#] = Me.[Patient#]
![Clinician#] = Me.[Clinician#]
![FeeStatus#] = Me.[FeeStatus#]
.....etc.......

In A2000 debug mode, looking at Me.Patient# or any of the form fields,
show
null values. In my A2003, the fields show correctly as valued from copied
record.
I'm using SQL Express - them sql 2000.

I've set references to ADO lib, DAO lib, etc in their A2000.

Any ideas as to why not working in A2000 hugely appreciated.

Thanks!
Don