dropdown list with sections on a form

[kull]

Hi Folks<br><br>I have a combo box set up on a form that accesses a table with a field listing provinces and states.&nbsp;&nbsp;How would I go about making it so that when I open the drop-down list on the form, the provinces are listed together under a header of &quot;Canada&quot; and and the states are under the header &quot;United States&quot;, and the user cannot select the headers off the list.&nbsp;&nbsp;Thanks in advance for any help.&nbsp;&nbsp;<br><br>

 

[jimmythegeek]

Can't be done.<br><br>There is no way to have headers mixed in with the data. The only header is at the top.<br><br>If you have a field in your table that specifies whether it is a state or province, you could sort first by that field, and then by the actual state or province. This would give you all of the provinces together, and then all the states. I believe that is as close as you can get.<br><br>The other option is to have a combo box for provinces, and a combo box for states. <p>Jim Lunde<br><a href=mailto:compugeeks@hotmail.com>compugeeks@hotmail.com</a><br><a href=

http://www.cgeek.com>CompuGEEKS</a><br>Custom

Application Development