<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2726.2500" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=451490316-24072003><FONT face=Arial color=#0000ff size=2>There
is a bug in A2K that causes it to lose the unique table information when you're
in design mode. The workaround is to re-select it every time you open the form
in design mode. This assumes that your form's recordsource is based on more than
one table (i.e. a view or a sproc or merely a select statement that uses at
least two tables).</FONT></SPAN></DIV>
<DIV><SPAN class=451490316-24072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=451490316-24072003><FONT face=Arial color=#0000ff size=2>Should
any of your tables have no PK, they will be read-only (from
Access).</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=451490316-24072003><FONT face=Arial color=#0000ff
size=2>Arthur</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Liam
Meadows<BR><B>Sent:</B> July 24, 2003 6:45 AM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD] Unique Table keeps
dissapearing in ADP<BR><BR></FONT></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>I am just starting to get my head around ADP using
Access 2000</FONT> <BR><FONT face=Arial size=2>I have one form which generates
purchase orders but everytime I open it it is completly blank no fields or
nothing just the header as soon as I choose the unique table field in the form
properties everything comes back as normal. The form opens in add new record
only. Any idea's why this happens. ?</FONT></P>
<P><FONT face=Arial size=2>Cheers</FONT> </P>
<P><FONT face=Arial size=2>Liam</FONT> </P></BLOCKQUOTE></BODY></HTML>