Incompatibility Issue

Hi,

The code below works for me at home. All it is meant to do is to populate a listbox (using the .AddNew property) with clinic names of the same postal code.

recNum = 0
Do While Not rsPcode.EOF
pcodeClinics.AddItem rsPcode!ClinicName, recNum
recNum = recNum + 1
rsPcode.MoveNext
Loop

Now, on a related machine using Access2000 the same line gives me an error. It points to the .AddNew routine for the listbox with teh error that it does not have that property.

Is this possible a version problem? Is there anyway of fixing this?

Thanks,

Sounds as though the database doesn't have the same column name in live as it did in test.