An expression with no value

[HandJT]

Hi

I wrote a code in VBA for my Access database. When I fill out the form in which the code is in, Access runs through the code with no problems when I save it, however I get a message box that says "You entered an expression that has no value." I have worked the last two days trying to figure out why this would pop up. I went through my code over and over and everything seems right. My question I guess would be what are some common problems as to why this message box would pop up?

Note: It also doesn't execute any of the procedures that is within my code, but like I said no errors come up other than the message box. Any suggestions?

 

[formerTexan]

Hello,

You haven't provided your code, but a guess is that you are trying to pass values from a recordset that hasn't returned any records.

Step through your code and see where the error occurs.

Cheers,
Bill