If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Default value in combo box
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 -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
Default value in combo box
"syedalna via AccessMonster.com" u29806@uwe wrote in message news:6a41ffb821f3e@uwe... 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 -- Message posted via http://www.accessmonster.com Could you use category.ListIndex = index? category.ListIndex = 0 ' selects first item in list Sean |
#3
|
|||
|
|||
Default value in combo box
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.. Sean wrote: 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200612/1 |
#4
|
|||
|
|||
Default value in combo box
You need to put in a value instead of index
0: first item in list 1: second item 2: third etc., "syedalna via AccessMonster.com" u29806@uwe wrote in message news:6a485afd22f61@uwe... 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.. Sean wrote: 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200612/1 |
Thread Tools | |
Display Modes | |
|
|