<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4134.600" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial color=#0000ff size=2>I would like to amend several combos
in my app to have the option of 'Add new record' at the top of the
list.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>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:</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>SELECT [TblClients].[BorrGuarID],
[TblClients].[BorrowerName], [TblClients].[AddressLine1],
[TblClients].[AddressLine2], [TblClients].[BusPostCode], [TblClients].[ACN] FROM
TblClientsORDER BY [TblClients].[BorrowerName];</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>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....</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>TIA</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Kath</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Kath Pelletti<BR>Software Design
& Solutions Pty Ltd.<BR>Ph: 9505-6714<BR>Fax: 9505-6430<BR><A
href="mailto:SDSSoftware@Optusnet.com.au">SDSSoftware@Optusnet.com.au</A></FONT></DIV></BODY></HTML>