Strange error in detail_format

Carnafex

Registered User.
Local time
Today, 15:01
Joined
Jan 19, 2004
Messages
38
Okay, this ranks pretty high on my strange'o'meter.
Firstly, the report in question simply prints out a report listing all outstanding orders (with their duedate and misc. details.
The report used to work fine, then recently, every time I open the form it chucks an error.

  • Run Time Error '2465'
    Microsoft Access can't find the field '|' referred to in your expression.
I get what the error means but I've never seen it do this before. If I press debug it lists this line:

  • If ([TextStockRemaining] <= 1 AND Date() <= [DueDate]) then
    'other simple stuff
So anyone out there have any ideas why this is occuring?
It vexes me so...

Thanks
Jason
 
I managed to fix the error.

For those wondering, it was simply caused by a invalid field name (TextStockRemaining). This was caused by a wrong version of the report being imported from another database.
Strange that it said '|' as invalid as opposed to 'TextStockRemaining'.

Ah well, everythings working now.

Cyas
Jason
 

Users who are viewing this thread

Back
Top Bottom