Software Design & Solutions Pty Ltd.
SDSSoftware at optusnet.com.au
Wed Jun 4 20:01:08 CDT 2003
I would like to amend several combos in my app to have the option of 'Add new record' at the top of the list. I use 'not in list' code extensively to write new records to tables and open user input forms, but I now have a requirement for the user to *see* 'Add new record' as an option. Because I have to do this for several different combos, there are a few different scenarios, but here is the row source statement for one below: SELECT [TblClients].[BorrGuarID], [TblClients].[BorrowerName], [TblClients].[AddressLine1], [TblClients].[AddressLine2], [TblClients].[BusPostCode], [TblClients].[ACN] FROM TblClientsORDER BY [TblClients].[BorrowerName]; I have a feeling that I need a union query to pull in a value of 'add new record' so I have had a go at that with no luck.... TIA Kath Kath Pelletti Software Design & Solutions Pty Ltd. Ph: 9505-6714 Fax: 9505-6430 SDSSoftware at Optusnet.com.au -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030605/f746cc33/attachment.html>