Author: Kent Belan
Posted: 2011-08-07 at 14:40:38
Hello Jeff,
I have been using the DBI control ctCombo and it does what you are looking
for.
It has an auto complete feature and an auto save option.
HTH,
Kent
-----Original Message-----
From: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] On Behalf
Of Jeff Johnson
Sent: Sunday, August 07, 2011 10:27 AM
To: profox@leafe.com
Subject: Re: Different Combobox Behavior
On 08/06/2011 02:08 PM, Alan Bain wrote:
> Check out the quickfill class on universal thread. It may do what you
> are wanting. I use the quicken style textbox but haven't used the cbo
> class.
>
> http://www.universalthread.com/ViewPageNewDownload.aspx?ID=9349
>
> or search for quikfil3.zip
>
> HTH,
> Alan
>
>
>
> On Sat, Aug 6, 2011 at 2:35 PM, Jeff Johnson<jeff@san-dc.com> wrote:
>> I have customers that use a combobox to enter quite a few things. I
>> was asked it they could have the combobox to select an item in the
>> lookup table, but be able to enter something in the combobox that is
>> saved to the file without adding it to the lookup table.
>>
>> For example, the combobox currently is basically a drop down list.
>> If I change it to a combobox the usual behavior is to give the user
>> the option to add it to the lookup table.
>>
>> I want to be able to add it to the file but not add it to the lookup
>> table and when I return to that record, the user entered information
>> comes up even though it is not in the record source.
>>
>> For my applications this would be the preferred behavior but I have
>> not seen it anywhere. Even Quickbooks requires you to add and
>> account or vendor to the lookup table before continuing.
>>
>>
>> --
>> Jeff
>>
>> ---------------
>>
>> Jeff Johnson
>> jeff@san-dc.com
>> (623) 582-0323
>>
>> www.san-dc.com
>>
>>
Alan: Thanks for that! That is what I am looking for but in a combo box
where you can pull down a list or enter one that is not in the list. For
example, you enter an "S" and it fills in the first entry that starts in
"S." I would like to hit a down arrow, the arrow on the right or something
like that and have a list come up to choose from. If they don't want to
enter from the list, I just keep typing and it saves the entry in the
control source without adding it to the lookup table.
This may be under-simplification but I thought of automatically adding it to
the lookup table without the user knowing about it and "hiding" it when
viewing or editing the lookup table.
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/288D419381D4445D8EB364A1CB74B869@LaptopW7
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.