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 |
|
mikey
Starting Member
1 Post |
 Posted - 2004-02-29 : 23:58:00
|
| in a form:how do you automatically update a textbox after u've clicked a value in combo box with the value matching in the same row.eg. say you selected a name in the combo box, it will automatically update 2 text boxes with matching addresses and birthdays from the same row.here's a rough sample code i've tried to implement which doesn't worktext4.value = "select distinctrow cables from [pricing]" _& "Where rating = [forms]![pricing]![rating]"i've spent hours. and tried different other things like on change etc. still can;t get it. smart it dudes out there please help!thanks Mike |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-03-01 : 05:50:38
|
| That will put the text "select distinctrow cables from [pricing]Where rating = [forms]![pricing]![rating]"into text4.I suspect you want to query the table and put the result into the textbox (maybe by a bound textbox if that's available but I would do it explicitly). And want the value of "[forms]![pricing]![rating]" rater than the text.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
hours and i still can't do it