combobox

[Irie]

I have a combobox, which has many columns, and depending on what value I select in this combo it brings up relevant information in other txtboxes.

How do I get the first value to appear in the combobox, and have its related txtboxes already filled with the related information?

Basically automatically choosing the first value in the combobox without having to actually select it?!?

Any suggestions would be great.......

 

[shacket]

If that is a fixed record, you could put the value for the Bound Column in the default value of the combo box.

 

[Irie]

Thanks for the reply Shacket....
Your suggestion works to the point that the first value is displayed in the combobox, but all the other txtboxes remain blank.

I got it to work by combining two comboboxes that I had, that were each based on a seperate query. I then just combined the queries and it worked.....