General information
Category:
Forms & Form designer
>>>>>>>>I have a combo, .Style = 0-dropdown combo, .RowSourceType = 1-Value, Rowsource = TBD,N/A,VARIOUS, ControlSource = mytable.myfield. I thought that .Style = 0 meant that I could enter anything in the control, but it's not showing what I type, unless I select or type one of the three values in Rowsource. Since, for testing purposes, I have left in an old textbox with the same controlsource, I can see that values other than these three are not being saved to the table. What's going on?
>>>>>>>
>>>>>>>I guess, the problem originated from ControlSource. Personally, I don't use this property at all. Basically, combo will work this way:
>>>>>>>Combo.Lostfocus event:
>>>>>>>if this.dispalyvaluethis.value
>>>>>>>This.additem(this.displayvalue)
>>>>>>>endif
>>>>>>>Use Value property when you "Save" the record to fill appropriate field.
>>>>>>
>>>>>>I wasn't sure what "if this.dispalyvaluethis.value" meant.
>>>>>
>>>>>Yes, I just forgot that this is HTML and missed the symbol. Sorry, about this.
>>>>>
>>>>> Perhaps "if this.displayvalue # this.value". I didn't want to add items to my combobox, and I wasn't sure how .displayvalue was used here. My combo has only one column. I did try removing the .ControlSource and putting a REPLACE myfield WITH THISFORM.combo.Value. Now my typed value remains visible in the combo, but is still not added to the table.
>>>>>
>>>>>If you want to use existing items only, then set Style=2. If you want to type something else, you must add items to RowSource.
>>>>
>>>>I want this control to display the value of the field during navigation, and offer a few choices: TBD, N/A, and VARIOUS when adding and editing. It sounds as if the dropdown combo with style=0 is useless, because of the requirement to always use .AddItem, which will not be possible when just navigating the table. Maybe I should superimpose a textbox and make the combo visible only in edit mode.
>>>
>>>No, drop-down box is ehough itself. BTW, you can also use simple textbox with Format="M" and inputmask="TBD,N/A,VARIOUS"
>>>>
>>>>By the way, when I actually looked at the documentation, I noticed that it says to put the .AddItem in the .Valid, not .LostFocus. But I found that when I entered a value and then clicked on a nearby editbox, .Valid never fired, and the value was wiped out. I found no problem when I put the code in .LostFocus, as you said to do. It sounds as if you know more than the guy who wrote the book.
>>>
>>>Thanks.
>>
>>I don't want preset choices. I just want to offer some choices during adding and editing. In a majority of cases, those choices will not be used. But they are used often enough (5-10%) to make them worth offering. How do you make a combobox display a field value during simple navigation when the field value is usually not one of the choices?
>
>The simplest way is just to add one more item (SPACE(1)) to combo and use it in 90% cases.
I don't see how that helps. The 90% of cases are not SPACE(1). They are various numbers, in character format.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only