Forms and Tables

[jerold]

I have a form1 that uses table1. In the form1 it has cmdsearch.click that opens form2. In the form2 I have a cmdfilter.click that will filter the table1 based on the input on the form2.
Could somebody help me on how I could access the table1 in this form2 and then open the form1.

legend: table1 = applicant.dbf

cmdfilter.click contains
..checking
use applicant
set filter to ...
thisform.release
do form form1

error: File is in use

Please help me setup the proper code

Thank you.

 

[vdeveloper]

Hi Jerold

try this

define form2 as modal

in cmdsearch.click
do form2
THISFORM.refresh() ( will refresh form1 data)

in form2 > cmdfilter.click do not issue do form form1 again since the form1 is already open

also if you are using dataenvironment in form2, set autoopentables and autoclose tables to .f this will prevent your table opened in form1 from being closed in form2

please feel free to email me for further assistance.

vdeveloper_2000@yahoo.com

Regards

Vdevelop