Problems creating new field

[bodmin]

Hi guys,

I have created a new database, and a table that I am going to export data to, the problem I have is when I am creating the fields I keep getting a Type Mismatch error

Set fld = tdf.CreateField("ProductId", dbInteger)
tdf.Fields.Append fld

This is the code I have been using to create the field in the new database, anybody got any ideas why I keep getting this error message?

cheers in advance

 

[OnTheFly]

I don't think we have enough information. The code you are displaying should be fine. What is the code relavent to this before it?

 

[bodmin]

Have fixed this problem now, was a problem with my variable declaration had missed the DAO of the front of it

cheers