Open a Form by clicking a record in a Subform in a Main Form

[dinoliciouz]

Hi guys. I'm a newbie in MS Access. I only have very basic knowledge in micros. So my database is like:

Main Form: Document Detail
Subform: Document History
Other Form: Request for Document Change


All form has the same primary key "RequestID" as they are all created from the same Table:Request.

What I'm trying to do: When clicking a record in the Subform, the Other Form is opened.

In the RequestID OnClick properties of the Subform, I use the OpenForm action and set the Where Condition to:
[RequestID]=[Forms]![Document History]![RequestID]

Problem:
- When clicking a record in the Subform on the Main Form, the Other Form won't open. I'll get a popup "Enter Parameter Value".
- However, if I open the Subform alone and click on any record, it opens the Other Form and displays the specific record.

Please help. Thanks very much.

[pdebaets]

When opened as a subform, the form is not a part of the Forms collection. So [Forms]![Document History] is undefined. When opened stand-alone, it IS a part of the Forms collection, so the code works.

Try this as the Where condition in your DoCmd.OpenForm statement (assuming that RequestID is numeric):

"[RequestID]= " & Me![RequestID]

[dinoliciouz]

Hi pdebaets,

Below is my code:

Private Sub RequestID_Click()
DoCmd.OpenForm "Request for Document Change", acNormal, , "[RequestID]= " & Me![RequestID], acFormReadOnly

End Sub

Now when I click on any record in the Subform - whether standalone or embedded in the Main Form - nothing happens!

What gives?

When opened as a subform, the form is not a part of the Forms collection. So [Forms]![Document History] is undefined. When opened stand-alone, it IS a part of the Forms collection, so the code works.

Try this as the Where condition in your DoCmd.OpenForm statement (assuming that RequestID is numeric):

"[RequestID]= " & Me![RequestID]

[pdebaets]

Are you clicking on the RequestID control?

[dinoliciouz]

I'm clicking on a record in the RequestID column in the Subform.

[pdebaets]

Put a

MsgBox "Hi"

... statement just before your DoCmd.Openform method to see if the event procedure is being executed.