Linking forms without using subforms

[tomnsd]

I want to link a form to another form without making the form a subform. I have three forms; a "projects" form, a "projectsub" form, and a "taskmanager" form. I am trying to create a button on the "projectsub" form that will open the "taskmanager" form to a specific record. The common control in both forms is "projectid". This is the form control name and not the underlying table field name. I also want the ability for the form to populate with the "taskmanager" form to populate with the projectid from the "projectsub" form to create a new record in the "taskmanager".

[pbaldy]

Like this?

http://www.baldyweb.com/wherecondition.htm

[tomnsd]

Below is the code I added. The record that I want to select is on the subform of the mainform. When I run it a box pops up that says enter parameter value ITProjectID.

Private Sub Command42_Click()
DoCmd.OpenForm "project", , , "ITProjectID = " & Forms![Main]![Projects].Form![ITProjectID]
End Sub

[pbaldy]

The prompt is Access telling you it can't find something. Make sure that field is in the project form's record source, and that the form reference is correct.