combo box column 1 query

  • Thread starter Thread starter Mitchell_Collen via AccessMonster.com
  • Start date Start date
M

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
 
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
Click to expand...

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

John W. Vinson [MVP]
 
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.
 
Back
Top