i've created a menu form for the front end of my database, which has the option of either entering a new record in data entry mode or selecting a record through a filter query.

The data entry mode does not have any filters applied to it, yet when i click the command button (which runs a simple openform macro) i get a prompt to "Enter Parameter Value" for the name field...

i'm using Access 2002 on windows XP
thanks
Dom

Wow, macros.

The code on the button is opening a data entry form? What is the recordsource for the data entry form? Is it a query (sounds like it.) If so, what is the "name" field? "Name" is a reserved word and should not be used for a field name. Can you open the query without getting prompted for the parameter? That would make a difference.


mmcdonal

That's the problem - the command shouldn't be accessing a query at all - it should simply open the form and table in data entry mode with a completely blank record...

ok, having now changed the fieldname from "name" to "service user", that seems to have solved the problem!

thanks for that

Dom

That was simple then. good.

You may want to do some research into reserved words for reference. Also other naming conventions like no spaces etc. The Wrox books are pretty thorough on these topics.


mmcdonal