combo box column 1 query

[Mitchell_Collen via AccessMonster.com]

Can anyone tell me what this doesn't work? The function is supposed to refer
to the first column combo box.
FYI: the data comes of sql server.

SELECT Station, TxDatetime, Drawer, SubDrawer, Pkt, GenMedName,
BrandMedName, MedID, Amt, [Min], [Max], UserName, UserID, PtID, PaType
FROM dbo.phmPYXHx
WHERE (UserName = N'[Form]!PX_UserReports!combo0!Column(1)') <--
here is where i refer to column1 of the combo

Misty

 

[John W. Vinson]

Can anyone tell me what this doesn't work? The function is supposed to refer
to the first column combo box.
FYI: the data comes of sql server.

SELECT Station, TxDatetime, Drawer, SubDrawer, Pkt, GenMedName,
BrandMedName, MedID, Amt, [Min], [Max], UserName, UserID, PtID, PaType
FROM dbo.phmPYXHx
WHERE (UserName = N'[Form]!PX_UserReports!combo0!Column(1)') <--
here is where i refer to column1 of the combo

The Column property is zero based - Column(0) is the first column, Column(1)
the second.

John W. Vinson [MVP]

 

[Douglas J. Steele]

That looks as though it might be a pass-through query (it's dbo.phmPYXHx,
not dbo_phmPYXHx), in which case you can't refer to parameters.