ComboBox On Each Tab Sheet Page

[Jack Spratt]

I have four pages on a tab sheet, each page has its own combo box that has its own rowsource query. When I open the form each page's combo box value is 'null' until I make a selection. How do I get each combo box to show 'the first' row in its box, ie have the first row as its value ?

I've been trying everything, so it must be dead obvious !!

thanks

 

[mhartman]

Hello:

Simply set the default property of the combo to the value you want.

Regards

 

[Jack Spratt]

Many thanks - that now works fine when opening the form at the starting out page of the sheet, but even with default set for the combo's on the other pages - when you click on the page tab - the combo box values start out null until dropped and selected from !

 

[mhartman]

Hello:

An example is enclosed

Regards
Mark

In the DefaultValue property box, type [comboboxname].ItemData where n is the row that you want to use as the default. The ItemData property is zero-based, so type ItemData(0) if you want to make the first row in the list the default.

 

[Jack Spratt]

Thank you, thank you ! Now working like a dream.

 

[mhartman]

Hello

Your welcome and good luck with this!
Mark