Overflow Error '6' Help (1 Viewer)

[Jakboi]

Hello,

I am having this error when I use a form on a database I am building. What it is this.

I have a search form that search's a table for specific information that I put in the search criteria field on the form. Like name, dates, account number or whatever type of data I query.

Now it brings up a form with the list of matching criteria. When I click on one or select one it gives me that error.

I have searched around and need a little help.

What part is causing this? Is it somewhere in the query, the table, the form?

Thanks.

 

[vodafrog]

Overflow error '6' is normally caused by attempting to pass a long value into an integer field. Are you using any code during this process, if so ensure that you have not defined a variable as an integer and then trying to pass a long value to it.