'Enter Parameter Value' DOESN'T appear in 2K Runtime??

[salexc]

Hi all,

First post here so, please, be gentle with me

I have an odd (to me) question; I've got a query to search a table and I deliberately solicit user input by setting one of the query field criteria to '[Enter building ID to search]' (without the quotes, of course). In 2007 this brings up the 'Enter Parameter Value' box, renamed as appropriate, so the user can enter a building ID. In Access 2000 Runtime - nothing happens. Users have reported the same with the full version of Access 2000.

The query is called by a form event - I don't know if this makes any difference? Like I say, it works fine on 2007...I did a search of the forum, and Google, and I didn't find anything about the above method being unsupported in 2000 - so I'm stuck. Any ideas?

Many thanks,

Steve.

 

[vbaInet]

Do the users have the right permissions to run the query?

 

[salexc]

Yes - there are no permissions restrictions in place.

 

[vbaInet]

Was the query created in Access 2007?

 

[salexc]

That's correct - the whole database was created in 2007.

 

[vbaInet]

Recreate that query from scratch in 2003, import it into your 2003 version of your access db and see if that works.

 

[salexc]

OK - I'll have to get my hands on a 2000/2003 design environment; I'll give it a go and post back my results.

Thanks for your help.

 

[vbaInet]

You're welcome. Good luck!

 

[Boro]

Software is, as you know compatibile downwards

 

[SOS]

Software is, as you know compatibile downwards

Not always.