Append query based on a form field value has stopped working

[handlebars]

I have a access db written in A2k, with an append query that is referencing a field on a form using this messy code:

Expr1: First(CLng(Forms!tblOrders!ApplicationID)).

I am now trying to run the database from AccessXP and the same query returns no results.

Does anyone know why this may have happened?

Andrew

 

[dhookom]

returns no results" could mean lots of things but generally has more to do with criteria than columns/fields displayed. You might want to post your full SQL view.

BTW: having a form with the name "tbl..." is not very maintainable. "tbl" is usually used for table objects, while forms might begin with "frm", "sfrm", ...

Duane
MS Access MVP
Find out how to get great answers faq219-2884.