General information
Category:
Forms & Form designer
>>>>I have a combo box (actually dropdown list (style=2)) listing different types of software to choose from. I populate this dropdown using rowsourcetype=SQL Select and rowsource="SELECT desc FROM software INTO CURSOR query".
>>>>
>>>>I want to populate another table (CALLS.DBF) with the value of the selection so I set the controlsource to "calls.softwaredesc".
>>>>
>>>>I would like to use this dropdown to serve the dual function of showing what was previously entered, and allowing the user to change the value of what was previously entered. My problem is that is a record that was previously entered has a softwaredesc that is no longer in the software table, it will not show as the value in the dropdown list.
>>>>
>>>>Does anyone have any simple workarounds?
>>>
>>>I see a problem: why 'previous' record.softwaredesc is no longer in the software table? It's obvious contradictory to data normalization rules.
>>
>>For simplicity's sake, I described it that way... but in reality, it is still in the table, just marked as inactive. There may be cases where a piece of software that might have been a valid choice two years ago, is no longer available today, therefore not a valid choice today. We mark that software as inactive (a logical field in the software table) to maintain the data link to historic data, but it still doesn't solve my combo box problem.
>
>If your combo includes 'inactive' software too, it shouldn't be a problem to get requested functionality resetting Value property. I ,personally, wouldn't use ControlSource property here.
Why not use the ControlSource property? How am I to populate my calls.dbf if the ControlSource property isn't set?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only