Solved: Numeric Field Overflow

[lostin_space]

Hi all, i've got a form, which references a query to populate a drop down list... (it's basically just a sequence of PO numbers from a linked table...)

but every time i try to use it, it comes back to me with 'Numeric Buffer Overflow'...

So, i've checked & double checked everything... and it seems my original PO number query reverts with 'numeric buffer overflow' too!! what am i doing wrong??

it's just a recordset of numbers! :banghead: :dunno

Cheers

Russ

[matthewspatrick]

Russ,

My first thought is that you are trying to stick a number >32767 into an Integer type, or >2.1 billion into a Long data type...

[lostin_space]

no, purely numbers... was trying to query against the recordset....

[OBP]

Can you post a zipped copy on here?

[lostin_space]

I can't i'm afraid... i've managed to sort it now anyway...

Thanks for help.