I'm linking two tables that are both part of a company ODBC database with Access 2007. The query runs and displays data, but as I begin to scroll through the data, it returns the error message 'Invalid Use of Null' and all the fields change to ?Name. I don't understand the context of the message. The data I'm linking (called REP_NUM) is text in one table and a number in the other, so I used the function CSTR to convert the number to text in a query, then linked that new field in the query to the corresponding text field in the other table. My problem starts when I link the two tables, and as stated, it runs, but i can't scroll through all the data.
Can you help me understand the context or how to correct? I've read some of the messages about this message, but I can't understand how they apply to my situation. I cannot change the data tables (corporate table), I can only try to fix the queries.
Thanks in advance for any help!