<!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 6.00.2600.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial color=#0000ff size=2>Dear Kath</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>So David - are you trying to set the
application title to the person's name - if so then you really want to call
that for a new record, do you? Not until after the name has actually been
entered? Why not do this on the after update event of the name fields
(all).</FONT></DIV>
<DIV><FONT color=#0000ff>Yep, could do.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Is there more to it? Not that I
see.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>And why do you want the app title to
be the person's name?</FONT></DIV></FONT></DIV>
<DIV><FONT face=Arial size=2>For multitasking reasons, we seemed to conlcude it
is easier and more reliable to run several (same) Databases concurrently.
(Instead of running multiple instances of the same form) Naming each
instance in the title, thus also task bar makes it easy to identify the instance
one wants to go to!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>mmm I Think the space in [First Name] is
stuffing things a little, as it doesn't report its contents when hovering mouse
over, although others do...when stepping code. OK ignored
that!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Have fixed though, using </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>If Cap1 = "" And Cap2 = "" And Cap3 = ""
Then<BR>Cap1 = "Blank Form ID"<BR>End If<BR>If Me.NewRecord = True Then<BR>Cap1
= "Blank Form ID"<BR>End If</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>...in the function.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>And calling the function in the forms before_update
property also!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks again!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>Kind regards,<BR>David
Hingston<BR>_________________________________________________________________________<BR>Engines2Go
- Now THAT's a Search Engine!<BR>Automated major search engine manager<BR>Makes
searching quicker and easier - Have you tried it? <BR><A
href="http://www.engines2go.com/">http://www.engines2go.com/</A> <BR><A
href="http://www.cheqsoft.com/">http://www.cheqsoft.com/</A> The home of
Clipboard Express, MP3 Detective, TimesOwn and Break Reminder.</DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message -----
</DIV></BLOCKQUOTE></BODY></HTML>