Default value in combo box

[syedalna via AccessMonster.com]

I have MainForm & Subform100. in my subform100, i have combo Box [category].
This subform is set to data entry only and every time i need to add data... i
have to select [category]..which mostly the same in group of 30 to 60 records.


Is there away for me to simplified this task, i need to set the combo Box
default value temporary... and key in data entry without going through again
& again the [category] every each new data?

your help is needed to show me the way.

Thank you in advance

 

[Sean]

I have MainForm & Subform100. in my subform100, i have combo Box
[category].
This subform is set to data entry only and every time i need to add
data... i
have to select [category]..which mostly the same in group of 30 to 60
records.


Is there away for me to simplified this task, i need to set the combo Box
default value temporary... and key in data entry without going through
again
& again the [category] every each new data?

your help is needed to show me the way.

Thank you in advance

Could you use category.ListIndex = <index>?

category.ListIndex = 0 ' selects first item in list

Sean

 

[syedalna via AccessMonster.com]

It show error..

I copy the code in the combo Box before Update() to this

category.ListIndex = <index>?
category.ListIndex = 0 ' selects first item in list

Basically its not working..

I have MainForm & Subform100. in my subform100, i have combo Box
[category].

[quoted text clipped - 11 lines]

Thank you in advance

Could you use category.ListIndex = <index>?

category.ListIndex = 0 ' selects first item in list

Sean

 

[Sean]

You need to put in a value instead of <index>

0: first item in list
1: second item
2: third
etc.,

It show error..

I copy the code in the combo Box before Update() to this

category.ListIndex = <index>?
category.ListIndex = 0 ' selects first item in list

Basically its not working..

I have MainForm & Subform100. in my subform100, i have combo Box
[category].

[quoted text clipped - 11 lines]

Thank you in advance

Could you use category.ListIndex = <index>?

category.ListIndex = 0 ' selects first item in list

Sean