Access: Query question??

Hi all,

Kinda strange thing happening here. Ok i got two tables, with the same specs.
One table has records, the other is used for appending to. I create a query within code to append records to the other on the fly, and get a data type conversion error. I have no idea why this is happening. The tables are the same. But if I was to open the query in design then save it, there is no problem. Any ideas what the problem could be?

Post the code you are using

I went through the table and noticed some of the fields had bad data and it would crash when it started to convert. Thanks for the reply. I could of sworn I double checked the data before lol. :o