Arthur Fuller
artful at rogers.com
Thu Jul 24 11:19:05 CDT 2003
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). Should any of your tables have no PK, they will be read-only (from Access). Arthur -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Liam Meadows Sent: July 24, 2003 6:45 AM To: accessd at databaseadvisors.com Subject: [AccessD] Unique Table keeps dissapearing in ADP I am just starting to get my head around ADP using Access 2000 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. ? Cheers Liam -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030724/b7c27a6d/attachment-0001.html>