Using barcode scanner with combobox

[johndohnal]

Hi All,
I have a form with a combobox to select a combination of material, manufacturer, supplier, and packaging method. Each combination has its own material ID number. The combobox displays the name of the material, and there are several other boxes which display the manufacturer, supplier, and packaging method using the column function. I'd like to use a barcode reader to enter the material ID number in the combobox. However, when I use the reader, it shows the number, but then gives the following error message:

The text you entered isn't an item in the list. Select an item from the list, or enter text that matches one of the listed items.

Here is the SELECT statement for my combobox:

SELECT DISTINCT tblMaterialSpecifications.[ID], tblMaterialSpecifications.[MaterialSupply], [tblMaterialSpecifications].[Ambient], [tblMaterialSpecifications].[MonitoredRefrigeration], [tblMaterialSpecifications].[MonitoredFreezer], [tblManufacturer].[Manufacturer], [tblSupplier].[Supplier], [tblPackaging].[PackageType] FROM tblPackaging INNER JOIN (tblSupplier INNER JOIN (tblManufacturer INNER JOIN tblMaterialSpecifications ON [tblManufacturer].[ID] = [tblMaterialSpecifications].[ManufacturerID]) ON [tblSupplier].[ID] = [tblMaterialSpecifications].[SupplierID]) ON [tblPackaging].[ID] = [tblMaterialSpecifications].[PackagingID] ORDER BY [tblMaterialSpecifications].[MaterialSupply];

Any suggestions?
Thanks,
JohnD

 

[Mihail]

Hi All,
I have a form with a combobox to select a combination of material, manufacturer, supplier, and packaging method. Each combination has its own material ID number. The combobox displays the name of the material, and there are several other boxes which display the manufacturer, supplier, and packaging method using the column function. I'd like to use a barcode reader to enter the material ID number in the combobox. However, when I use the reader, it shows the number, but then gives the following error message: ????????????????

The missed text is more interesting than all you showed us

 

[spikepl]

If the error message is:

then the fix is:

 

[spikepl]

Well let's not be cruel. If you set the first column width to 0 then the control expects input corresponding to the first displayed column (i.e. width <>0 ) . Set that column width >0 and the barcode output might work (if it is a number and not a string - you should check (=run tests) what comes out of your barcode reader).

 

[johndohnal]

Currently, column 0 is set to Material ID number and a width of 0. Column 1 is set to Material Name with a length >0. The ID number is the key field and the Material name is what appears in the field after selection. I tried setting column 0 width to >0, but then a number appears in the field after using the barcode. I still need the name to appear in the field.

Also, sorry for the missing error message, it disappeared after I saved. I've included it now.