Combo Box : Guidance Required [message #259564] |
Thu, 16 August 2007 00:20 |
jhedspig
Messages: 2 Registered: August 2007 Location: pune
|
Junior Member |
|
|
There is a functionality i want to include in the combo box list :
If there is only one row in the table the list will show one value. In this case i want the only row displayed in the list to automatically populate the list field when the form is opened.
If there are many rows the list should show a blank value.then i will explicitely select from the list.
if there's a program where should i place it ?
what will be the code ?
hope i am clear...
regards.
|
|
|
Re: Combo Box : Guidance Required [message #260328 is a reply to message #259564] |
Sat, 18 August 2007 09:01 |
hemavb
Messages: 103 Registered: May 2007 Location: Dubai , UAE
|
Senior Member |
|
|
if you are fetching the data in the block(row) by a SQL query, why dont you use the same query to populate the combo-box/list.
If you do so, the IF - ELSE clause that you have specified will take care on its own.
incase you want the code to populate a list post back.
-Hemavb
[Updated on: Sat, 18 August 2007 09:02] Report message to a moderator
|
|
|
|