[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
>