passing values

[makisbest]

Hi All

How I can pass a value from a drop down menu in a form
to a query creteria?

Thanks

 

[ProgramError]

If the box is bound to a field then just put the name of the field in the criteria
ie. =[nameOfField]

Ian Mayor (UK)
Program Error
Programmers do it one finger at a time!

 

[ProgramError]

If the box is not bound then you need to use...
[forms]![NameOfForm].[NameOfComboBox]

Ian Mayor (UK)
Program Error
Programmers do it one finger at a time!

 

[makisbest]

How I can use a like statement

SELECT dbo_tblWarehousePositions.WPDescription, dbo_tblWarehousePositions.WPBarcode
FROM dbo_tblWarehousePositions
WHERE (((dbo_tblWarehousePositions.WPDescription) Like '[Forms]![Main]![combobox0]%'))
ORDER BY dbo_tblWarehousePositions.WPDescription;

 

[ProgramError]

Note the changes in the where statement

SELECT dbo_tblWarehousePositions.WPDescription, dbo_tblWarehousePositions.WPBarcode
FROM dbo_tblWarehousePositions
WHERE (((dbo_tblWarehousePositions.WPDescription) = [Forms]![Main].[combobox0]))
ORDER BY dbo_tblWarehousePositions.WPDescription;

N

Ian Mayor (UK)
Program Error
Programmers do it one finger at a time!

 

[makisbest]

Ok.

I want to use like statment not iqual (=)

How I can syntax that.

 

[AlexMidd]

Like '" & [Forms]![Main]![combobox0] & "'"

Have fun! )

Alex Middleton