>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