"Enter Parameter Value" dialog

  • Thread starter Thread starter Pat
  • Start date Start date
P

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?
 
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,
 
A typo in a query was the problem.
Thanks Cheryl

Cheryl Fischer said:
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,
Click to expand...
 
Back
Top