Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Forms and Tables

Forms and Tables

Forms and Tables

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
  use applicant
  set filter to ...
  do form form1

error: File is in use

Please help me setup the proper code

Thank you.

RE: Forms and Tables

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.




Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close