Software Design & Solutions Pty Ltd.
SDSSoftware at optusnet.com.au
Thu Jun 5 03:30:08 CDT 2003
Thanks Michael - I'm playing with that now. So I have to have the same no. of columns on both sides and use null for the unwanted ones. THanks Kath ----- Original Message ----- From: Michael R Mattys To: accessd at databaseadvisors.com Sent: Thursday, June 05, 2003 3:03 PM Subject: Re: [AccessD] Amend combo to have 'Add new record' option in list Kath, I think this may work (or something close to it): For each of your fields you would select NULL as that field name like so ... ... UNION SELECT NULL AS BorrGuarID, ... NULL AS [ACN], '!Add New Record!' AS [NewRec] FROM tblClients Michael R. Mattys www.mattysconsulting.com ----- Original Message ----- From: "Software Design & Solutions Pty Ltd." <SDSSoftware at optusnet.com.au> To: <AccessD at databaseadvisors.com> Sent: Wednesday, June 04, 2003 9:01 PM Subject: [AccessD] Amend combo to have 'Add new record' option in list 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 ---------------------------------------------------------------------------- ---- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030605/854bd336/attachment-0001.html>