Double Click Property - Help!

[Todd]

I have 2 forms based on the same table (table3). The first
form is a query based form (open deficiencies) and the
second form is just based on table 3 data (status). I am
having trouble building an expression such that when I
double click a deficiency # on the first form (open
deficiencies), the status form will open and show the
status of the same deficiency # as was double clicked.
Please help!

Todd

 

[Van T. Dinh]

Use the "wherecondition" argument of the OpenForm Method (which you need to
open the frmStatus) to filter the frmStatus to the required Record.

Check Access VB Help on the OpenForm Method, especially the "wherecondition"
argument.

There are other methods also but the "wherecondition" is generally the
simplest way, AFAIK.

 

[Guest]

I have tried this and for some reason I am unable to get
the right SQL statement. I keep getting a text box that
asks for me to input the deficiency # instead of going
right to the deficiency # double clicked.

Todd

 

[Guest]

I have figured it out. Thanks for the help!

Todd

-----Original Message-----
I have tried this and for some reason I am unable to get
the right SQL statement. I keep getting a text box that
asks for me to input the deficiency # instead of going
right to the deficiency # double clicked.

Todd

.