Subject Re: Drag Table to Design Form
From Andy Taylor <andy.taylor@which.net>
Date Mon, 21 Aug 2017 04:42:30 -0400
Newsgroups dbase.getting-started

Norman,

Lets assume your table is called MyTable and that you have not renamed any form objects automatically created by the designer.
If you have, then you'll have to translate the names to give us the properties we need to see.

When you run the form what are the properties for:
   form.MyTable1.active
   form.MyTable1.requestLive
   form.MyTable1.sql
   form.MyTable1.rowset.autoEdit
   form.MyTable1.rowset.live

The easiest way to find these is to insert the following line into the onOpen method of the form:
   inspect(form.MyTable1)
If you don't yet have an onOpen method for the form put this codeblock into the onOpen method using the form designer
   {;inspect(form.MyTable1)}

Andy

> I started a new form and copied an existing dbf table to Tables. I dragged the Table to the Design form and then copied existing code to the form. The sql icon appears on the design form.
>
> Using the ListBox to select a Record and running the Form produces correct results only  for each of  the seven original copied Records.  
>
> Oddly, Entryfield values  on the Form all appear the same for each of the total seven Records. I can change the Entryfields on the form and the changes are also shown in the Table. However, the changes are superficial as no new Entryfield data is processed when the Form is Run. The Form is not recognizing new input.
>
> Can  someone comment on why the database table is not connecting with new Records and  Entryfields on the form?
>
> Thanks, Norman Snowden