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.