Enter parameter shows in Access 2007 but not on 2003

[Fernando]

Well the title pretty much the tittle says what happens. The users using access 2007 will get this "Enter Parameter Value" inputbox, but the 2003 users donut. I know that when you get an "Enter Parameter Value" is a problem in the record source of ur forms or subforms which i couldn't find, however i will keep looking for it. Its a Date field that its missing which i use in other forms but not this one.

 

[Fernando]

I just discovered i had stuff in the OrderBy Property, (the missing field).

I went to the users machine to edit the program and discovered that:
Access 2007 forms has 2 new properties Filter On Load, OrderBy On Load

Since by default they are set "Yes" it asked for the parameter.

Moral of the story: Always check your OrderBy and Filter properties before using ur db in Access 2007