>>I'm interested in building a ComboBox picklist that has a '< New >' selection in it (like Quicken's Pulldown picklists).
>>I don't like the idea of using a view as the RowSource, because of the constant Requery()s, so I'm thinking of using the base table and (1) appending a blank record (with '< New >' as the name), (2) deleting it (and re-appending it if a pack is done), (3) always using buffering for the forms that use it, and (4) Recalling it in GotFocus() and Deleting it again in LostFocus().
>>
>>What kind of problems do you think I'll run into?
>>
>>TIA
>Bill,
>With "new" as an option it's open to false newitems, right (ie: Mushroom where already MUSHROOM exist or A.Appendicitis where Acute Appendicitis already is there) ? If this is acceptable what about setting rowsource to SQL (distinct) and union current displayvalue in a common upper, lower or proper format?
>Cetin
Hi Cetin,
I got a little lost in your explanation, so if I misunderstood, please correct me.
About 'false newitems': I don't think there is any way to prevent those kind of problems (users will always overlook what is in the list).
I'm trying to avoid having to do constant Requery()s to keep the list current, and I assume that setting the RowSource to SQL would require that.
Did I misunderstand something?
Bill Morris