Tricky Error: -2147417848

[mishbaker]

The Setup:

I have a main form with a listbox to the left and a subform with a listbox on the right. As the user selects an item from the main listbox the listbox on the subform(to the right) should update to reflect such.

When the rowsource to the subform contains a query with:

right([NSN], 11)

I get the above error when it reaches the following line of code:

    Me![frmSUBAssignDocs].Form![List8].Requery

When I remove the 'right' function and the query is just matching the [NSN] field things are ok. But with the 'right' function present I get that error on all machines running WinXP Pro 2002 w/ SP1. No problems on WinXP Pro without the SP1 nor on Win 2k w/ SP2.

For the time being I have removed the 'right' function, but was wondering if there was something I could do to allow me to use the 'right' function and not get that error?

Thanks guys

P.S. The NSN field does contain "-" characters along with numbers, stored as text. I did some searching and found a similar error with that as a problem, but no fix to my specific issue.

All lessons learned from the School of Hard Knocks........at least tuition is cheap.

 

[PaulF]

did you check to ensure that there are no references listed as "Missing"? This might be an indication of that problem.

PaulF

 

[mishbaker]

I checked. All of the computers are running the same references. Visual Basic for Applications, Microsoft Access 9.0 Library, OLE Automation, and Microsoft ActiveX DObj 7.1.



All lessons learned from the School of Hard Knocks........at least tuition is cheap.

 

[PaulF]

one more thing to check is to see if all records have an NSN (although I really don't think this is the problem).. you might try using the Nz function such as:

Right(Nz([NSN],"Not Listed"),11)

PaulF