>>I'm having two comboboxes on a form. The user as to selects from the first combobox.
>>
>>The second combobox is populated depending on what was chosen in the first combobox. There are times when there is only one thing to select from the second combobox.
>>
>>How can I make that selection from that combobox automatic so that the user does'nt have to click on that combobox when there is only one item to be selected from that second combobox?
>
>When you programmatically load the second combo, set it's value to the default value. There you go.
>
>In the interactive change of cboONE
>
>SELECT * ;
>FROM tblTWO ;
>WHERE tblTWO.Column = cboOne.Value ;
>INTO CURSOR curTWO
>
>cboTWO.RowSource = "curTWO"
>
>cboTWO.Value = [Insert the value here]
>
>How you arive at the value for cboTWO is another problem because I expect it could be different depending on the value selected in cboONE.
>
>Hope this helps ...
>
>J.
Thanks Jason
*******************************************************
Save a tree, eat a beaver.
Denis Chassé