Continuous Form

[Guest]

I have a Dashboard with a subform that is a continuous form. The subform is
a summary list of all audits in the database.
I want the user to be able to click on the audit number listed in the
subform and have another form "frmAA" open filtered to that particular audit
and ready for editing.

I've seen attempted solutions posted but results have been either the frmAA
opening to a blank record or opened to a particular audit regardless of the
audit that was selected.

Thanks in advance,

kljohn

 

[tina]

should be easy enough. the audit table has a primary key field, correct? and
that field is included in the "summary list of all audits" subform, correct?
if you answered, no to either question, stop here and do what's necessary to
change the No answer to Yes.

in the subform, you'll run code to open frmAA, using the WhereCondition
argument in the action, as

DoCmd.OpenForm "frmAA", , , "pk = " & Me!pk

replace the first "pk" with the name of the primary key field in the audit
table. replace the second "pk" with the name of the field *in the subform*
that contains the primary key of the audit table.

run the code wherever you want in the subform's Detail section: in the
click or double click event procedure of a control, or a command button,
etc.

hth

 

[Guest]

Tina - Works great - thanks. The PK was my problem.