<!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>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. </FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>THanks</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>----- Original Message ----- </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=michael.mattys@adelphia.net
href="mailto:michael.mattys@adelphia.net">Michael R Mattys</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, June 05, 2003 3:03
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] Amend combo to
have 'Add new record' option in list</DIV>
<DIV><BR></DIV>Kath,<BR><BR>I think this may work (or something close to
it):<BR>For each of your fields you would select NULL<BR>as that field name
like so ...<BR><BR>... UNION SELECT NULL AS BorrGuarID, ...<BR>NULL AS [ACN],
'!Add New Record!' AS [NewRec]<BR>FROM tblClients<BR><BR><BR>Michael R.
Mattys<BR><A
href="http://www.mattysconsulting.com">www.mattysconsulting.com</A><BR><BR>-----
Original Message -----<BR>From: "Software Design & Solutions Pty Ltd."
<<A
href="mailto:SDSSoftware@optusnet.com.au">SDSSoftware@optusnet.com.au</A>><BR>To:
<<A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A>><BR>Sent:
Wednesday, June 04, 2003 9:01 PM<BR>Subject: [AccessD] Amend combo to have
'Add new record' option in list<BR><BR><BR>I would like to amend several
combos in my app to have the option of 'Add<BR>new record' at the top of the
list.<BR><BR>I use 'not in list' code extensively to write new records to
tables and open<BR>user input forms, but I now have a requirement for the user
to *see* 'Add<BR>new record' as an option. Because I have to do this for
several different<BR>combos, there are a few different scenarios, but here is
the row source<BR>statement for one below:<BR><BR>SELECT
[TblClients].[BorrGuarID],
[TblClients].[BorrowerName],<BR>[TblClients].[AddressLine1],
[TblClients].[AddressLine2],<BR>[TblClients].[BusPostCode], [TblClients].[ACN]
FROM TblClientsORDER BY<BR>[TblClients].[BorrowerName];<BR><BR>I have a
feeling that I need a union query to pull in a value of 'add new<BR>record' so
I have had a go at that with no
luck....<BR><BR>TIA<BR><BR>Kath<BR><BR><BR>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><BR><BR><BR><BR>----------------------------------------------------------------------------<BR>----<BR><BR><BR>>
_______________________________________________<BR>> AccessD mailing
list<BR>> <A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR>>
<A
href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>>
Website: <A
href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</A><BR>><BR><BR>_______________________________________________<BR>AccessD
mailing list<BR><A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR><A
href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
<A
href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</A><BR></BLOCKQUOTE></BODY></HTML>