>>>>The problem is not where the record pointer is after returning from FormB but where the record pointer is once FormB is executed. FormB prompts user for some information that is saved in Table2. If the record pointer is not on new record then the new information will overwrite another record.
>>>>
>>>>Mike Laubach
>>>>mlaubach@mt-solutions.com
>>>
>>>Ok, and this problem can be handled too, regardless real pointer place. You could add parameters calling Form B, e.g. Do Form B With Table2.Primarykey. When you want to retrieve information from the table (being in FormB), you fire code like:
>>>Select Table2
>>>Set order to tag Primarykey
>>>Seek Thisform.Table2key && table2key is form property set to accepted parameter value in FormB.Init.
>>
>>I have already tried this but by passing the record number of the record that it should be set to. But it still does not work.
>>
>>insert into table2 ....
>>x = recno('table2')
>>do form formb with x
>>
>>formb.init
>>----------
>>parameter pn_recno
>>
>>select table2
>>go pn_recno
>>
>>Mike Laubach
>>mlaubach@mt-solutions.com
>
>No. Save pn_recno in Thisform.newproperty and use go Thisform.newproperty immediately before you retrieve data from the table (e.g. in Form.Activate event). It must work...

But I am worried about where the record pointer is in FormB not in FormA. When I go to save information in Formb that is where the problem is because it is not on the newly inserted record.

Mike Laubach
mlaubach@mt-solutions.com