Combo boxes

[wildexodus]

Is there any way to make a combo box automatically select the top value (or only value) in the list with having to specify a value in the properties? This is because the options in my combo change each time.

 

[llkhoutx]

Set the Default proptery value of the combo box to the value you want.
If you don't know it use a recordset to find it and then store it in the combo box.

 

[wildexodus]

What i probably should have explained is that there is only ever 1 value in the combo but it changes depending on the value of other combos on the form. What i want is for the combo to automatically select the only value in the combo. I was just wondering if there was any code i could put into the default value property that would make it automatically select the top value.

 

[llkhoutx]

Index that default value with a 1, then set the default value to 1 and you index shows. If you only ever have one value in the combobox why are you using a combobox?

 

[snagrat]

I also want to know how to do this.

I have a combo and when the product is selected another combo changes dependind on what is selected on the first.

Howver I want the second combo box to display the first in order automatically as this is usually the required value.

So how exactly do I do this?? I don't really understand

 

[llkhoutx]

I also don't understand what you're doing.

 

[Idjit]

wild,

If you only ever have one value in this field, why not just use a text box instead?

 

[wildexodus]

Because i tried that and i couldnt get it to work. First i was trying to use Dlookups and that went horribly wrong. To be honest, im a complete novice, and i need to keep it simple really, but im having a lot of trouble doing so.

What i also tried to do was to put a txt box on my form, and the copied the row source from the combo and pasted it into the control source for the txt box. This didnt work, it just said #name in the txt box.