Hi. I've been using Access for a couple of years now, but everything I know about it is self-taught. This makes me a little self-conscious/worried - I feel like I know how to do a lot, but I could have glaring gaping holes in my knowledge base that I don't even realize....ANYWAY, I'm working in Windows XP, with Access 2003. I've made this report that was fine until just recently. It doesn't have any error indicators, everything is doing exactly what I am telling it to, but every time I open it up or switch from page to page I get a popup window that says
Microsoft Office Access
"The value you entered isn't valid for this field.
For example, you may have entered text in a numeric field or a number that is larger than the FieldSize setting permits."
I don't have any idea why it started, but it didn't occur until I switched the datasource from the main table to a new query... When I run the query, everything works fine - the only thing I could take a stab at being the reason (but I have no idea the possible why's or how's) is because one of the values in the query is listed in a separate lookup table. But like I said, everything is doing what I want it to do! It's just annoying as HECK - it pops up when I print too, so printing the stupid thing, I had to press the OK button as many times as there were pages in the report. UGH!
I've searched through the troubleshoot/help section and also the MS Access online stuff--- I think my main problem is that I have no idea what it is referring to, and everything else seems to be fine, so I have no idea what to try and adjust even...
Any hints on why it suddenly started doing this would be very VERY appreciated!
Thanks,
Josta