Bill,
I use:
create cursor dummy (field1 c(10)...)
append blank
replace field1 with "**ADD**"
select ... from .. order by 1 union select ... from dummy
that pulls in the add or new or whatever addition I wnat to have
Peter
>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
Peter Cortiel