Open Form Action Button

I have a form and a subform setup in access as two separate forms. On
the main form I do a search for a particular project that I want to add
comments to by using the subform. Once I find the project, I have a
button on the form to open the subform to add history to it, but when
the subform opens, the project that is shown does not match the project
I searched for in the main record .

How do I get the subform to open and match the project on the main form
automatically?

Thanks!


--
mafhobb
------------------------------------------------------------------------
mafhobb's Profile: http://www.hightechtalks.com/m428
View this thread: http://www.hightechtalks.com/t2300861

On Sun, 4 Dec 2005 03:44:12 +0100, mafhobb
wrote:


I have a form and a subform setup in access as two separate forms. On
the main form I do a search for a particular project that I want to add
comments to by using the subform. Once I find the project, I have a
button on the form to open the subform to add history to it, but when
the subform opens, the project that is shown does not match the project
I searched for in the main record .

How do I get the subform to open and match the project on the main form
automatically?

Thanks!

Well, this isn't a subform. A Subform is a form that's in a Subform
control on a main form. What you're talking about is a popup form,
which is quite different!

You'll need to either drag the second form onto the first (perhaps
onto a Tab Control so you don't need to use too much screen space) and
make it a subform; or modify the VBA in the click event of the button
to pass the project ID:

DoCmd.OpenForm strDocument, WhereCondition := "ProjectID = " _
& Me!txtProjectID

or code to that effect.

John W. Vinson[MVP]