Query parameter problem

[Rzadziu]

Hi,



I have create the Access project file and plugged it into a Microsoft SQL database.
I have create also a query and a form with a combo box that should control the query.
Unfortunately, when I try to add a parameter Access show me error measage "Wrong type of data"
http://screenshooter.net/8947036/ycedyrc

Can anyone knows how to resolve my problem?

BR Marcin

[June7]

What are settings for these properties of the combobox:
RowSource
ColumnCount
BoundColumn
ColumnWidths

Is OrdNo field a text or number type?

[Rzadziu]

Hi,
Row source is from query http://screenshooter.net/8947036/xnmhect

OrdNo properties - http://screenshooter.net/8947036/fgtstks

But biggest issue is that i can't put criteria of OrdNo as on first link.

[June7]

Verified OrdNo is a number type. Far as I can tell through the language barrier, the combobox properties seem appropriate.

My best guess is that the parameter used in the query is under the wrong field. The combobox is probably bound to numeric primary key field. The parameter referencing combobox must be under a number field.