"Enter Parameter Value" dialog

[Pat]

I am getting an "Enter Parameter Value" dialog when I try to open the Orders
form. It refers to the table Order Details.tPriceEach If you are familiar
with Northwind the database I am creating is in many ways very similar. The
field properties for PriceEach is identical to Northwinds UnitPrice field
properties.

Anybody know why this should be happening?

 

[Cheryl Fischer]

That message often appears when the database cannot find a particular field
name in a query or in Open Arguments for a form or subform. I notice in
your posting that you are referring to the field in the error message as
"tPriceEach" and later in your posting as "PriceEach". Perhaps a typo in
some code behind a form or subform?

One way to check is to open any code module and do a search for
"tPriceEach".

hth,

 

[Pat]

A typo in a query was the problem.
Thanks Cheryl

That message often appears when the database cannot find a particular field
name in a query or in Open Arguments for a form or subform. I notice in
your posting that you are referring to the field in the error message as
"tPriceEach" and later in your posting as "PriceEach". Perhaps a typo in
some code behind a form or subform?

One way to check is to open any code module and do a search for
"tPriceEach".

hth,