Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-15 : 08:49:50
|
| Sevan writes "i have two combobox'sthe first one is conecting to access. which is just a list of itemCode, the 2nd one is a list from 1 to 7if the user select the first item which is 1 i want to write SQL to get the retail where = to itemcode from the DB according to the selection of the first combobox "itemcode" If CoolFlex1.Text = "1" Then CoolFlex1.Col = 1 **** SqlQ = "SELECT Retail FROM Inv_Item2 WHERE ItemCode = '" & CoolFlex1.Text & "" Set MyPriceDB = DBEngine.Workspaces(0).OpenDatabase(App.Path & "\CyprusMaria.mdb") Set rs = MyPriceDB.OpenRecordset(SqlQ, dbOpenSnapshot) CoolFlex1.Col = 6 CoolFlex1.Text = rs.Fields("Retail").Value End Ifthank you" |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-09-15 : 10:20:35
|
| Graz..I think you got the wrong forum...Anyway...your data source criteria needs to refernce the first combo boxBrett8-) |
 |
|
|
|
|
|
SQL