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
|
|||
|
|||
Restore combos to "blank"
On one form with combo boxes, when we data change in 1st
combo, anothers combos keep it old data. How is possible to force to appear "blank" the following combos in this case, please? Thanks in advance. an |
#2
|
|||
|
|||
Just set it to Null using the AfterUpdate event of the first combo.
me.Combo1 = null -- Sandra Daigle [Microsoft Access MVP] Please post all replies to the newsgroup. an wrote: On one form with combo boxes, when we data change in 1st combo, anothers combos keep it old data. How is possible to force to appear "blank" the following combos in this case, please? Thanks in advance. an |
#3
|
|||
|
|||
Exactly.
But one small nuance: "using the AfterUpdate event of the first combo" will be Me.Combo2 = Null .... Thank you for your help. an -----Original Message----- Just set it to Null using the AfterUpdate event of the first combo. me.Combo1 = null -- Sandra Daigle [Microsoft Access MVP] Please post all replies to the newsgroup. an wrote: On one form with combo boxes, when we data change in 1st combo, anothers combos keep it old data. How is possible to force to appear "blank" the following combos in this case, please? Thanks in advance. an . |
#4
|
|||
|
|||
Of course . . . unless your controls are indexed starting with 0!
I'm just playing of course but there *are* several collections in Access that are indexed starting with 0 so it's always a good to know the starting value! :-) -- Sandra Daigle [Microsoft Access MVP] Please post all replies to the newsgroup. an wrote: Exactly. But one small nuance: "using the AfterUpdate event of the first combo" will be Me.Combo2 = Null ... Thank you for your help. an -----Original Message----- Just set it to Null using the AfterUpdate event of the first combo. me.Combo1 = null -- Sandra Daigle [Microsoft Access MVP] Please post all replies to the newsgroup. an wrote: On one form with combo boxes, when we data change in 1st combo, anothers combos keep it old data. How is possible to force to appear "blank" the following combos in this case, please? Thanks in advance. an . |
#5
|
|||
|
|||
Certainly!
More one time... Many thanks. an -----Original Message----- Of course . . . unless your controls are indexed starting with 0! I'm just playing of course but there *are* several collections in Access that are indexed starting with 0 so it's always a good to know the starting value! :-) -- Sandra Daigle [Microsoft Access MVP] Please post all replies to the newsgroup. an wrote: Exactly. But one small nuance: "using the AfterUpdate event of the first combo" will be Me.Combo2 = Null ... Thank you for your help. an -----Original Message----- Just set it to Null using the AfterUpdate event of the first combo. me.Combo1 = null -- Sandra Daigle [Microsoft Access MVP] Please post all replies to the newsgroup. an wrote: On one form with combo boxes, when we data change in 1st combo, anothers combos keep it old data. How is possible to force to appear "blank" the following combos in this case, please? Thanks in advance. an . . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Restore button | George Randall | General Discussion | 3 | July 1st, 2004 11:57 PM |
Adding text to blank pages | Dave | Page Layout | 1 | June 9th, 2004 06:54 AM |
Return blank cell if cell to be tested is blank | John Richards | Worksheet Functions | 6 | June 6th, 2004 10:38 AM |
Want chart to be blank (gap) where a formula returns blank | Gav !! | Charts and Charting | 4 | January 7th, 2004 02:21 PM |