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 |
|
SupaHoop
Starting Member
8 Posts |
 Posted - 2004-03-03 : 06:34:33
|
| I have a problem with a combo box within an MS Access 2000 form. The access database is linked to an underlying SQL Server 2000 database.The problem I have is that the Combo box is bound to a stored procedure (only querying a single "employee" table). The procedure returns employeekey and employeename and the combobox displays the employeename. I have done this by setting the bound property to column 1 (employeekey), the coulumn count to 2 and setting the column width to 0cm;2.5cm. The combobox also has a ControlSource set which is a foreign key to the Employee table.The problem I have is that when you click in the combobox, the full list of employees is shown, but when you click on a different employee, the combobox text is not updated. However if you click on it a second time it works. This happens all the time, i.e. You need to click on the new employee twice (not a double click, just select it twice).I have run this in debug a number of times with breakpoints on every event available for the combobox - but each time the first click is not recognised!I have looked at everything I can think of, but still haven't been able to work out why on the first click the comboboxes events are NOT fired.Anyone out there with any idea's?____QPR's Blue & White blood runs through the veins.RTID |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2004-03-08 : 16:12:35
|
| SupaHoopI have created a combo box bound to a stored procedure, in precisely the way you describe, and get no "click" issue - that is, mine works as expected...So I'd say there's something else going on with your form.Step 1. Create a new form, new combo box, and try again- then post back here and let me know how you get on - and we'll work it through from there.--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
|
|
|
|
|
Combo Box Problem