Properly using a Select Statement

[Guest]

As example: I have a table called "WPS Data" containing the following data
"WPS" and "CE"

WPS CE
1A1457 212287
1A1468 212288
1A1475 212287
1A3212 83830
1A1469 212288

What I want to do on my form is when the WPS is selected from a drop down
list the associated CE is displayed in a COMBO box. I can not know how to
write the SELECT statement.

 

[Guest]

As I understand your situation, this may be simply a matter of changing
ColumnWidth. If your dropdown includes both fields (WPS; CE) and your
ColumnWidths are set to show WPS only:

Me.ThisDropdown.ColumnWidths = ".5 in;0 in"

after the click, just switch the numbers:

Me.ThisDropdown.ColumnWidths = ".5 in;0 in"

 

[Guest]

Sorry, I failed to switch the numbers:

Me.ThisDropdown.ColumnWidths = "0 in;.5 in"

 

[Guest]

Here's the code I created for the combo box, which doesn't work.

Select WPS Data.WPS &","& WPS Data. CE
From WPS Data
Order By WPS Data.WPS

The output I want should look like: 1A1457, 212287

 

[John Vinson]

Here's the code I created for the combo box, which doesn't work.

Select WPS Data.WPS &","& WPS Data. CE
From WPS Data
Order By WPS Data.WPS

The output I want should look like: 1A1457, 212287

Blanks are delimiters in SQL (or in VBA). If you (unwisely, in my
opinion) want to use blanks in tablenames or fieldnames, then you must
- no option - use [square brackets] around the name:

SELECT [WPS Data].[WPS] & ", " & [WPS Data].[CE]
FROM [WPS Data]
ORDER BY [WPS Data].[WPS], [WPS Data].[CE];


John W. Vinson[MVP]