Referencing Subform Control Source

[zappa007]

Hello forum world....

I've been banging my head against the wall for 2 days on this...any help/insight would be appreciated.

Objective: Open a main form, whose subform is value is defined by a control on a another form.

Background:
Main Form = frm_project_update
Sub Form = frm_resources_subform
Control Source to be Referenced = Name
Command Button resides on Form = frm_cm

What I've been able to do is open the subform directly from the command button on frm_cm. However, when I try and open the main form, it either be blank, have all values, or prompt me for a value (however, it is still blank)

Here is the code I've been playing with:

DoCmd.OpenForm "frm_project_update", acNormal, , "[Forms]![frm_project_update]![frm_resources_subform]![GSS_Name] Like ""*" & Me.Name & "*"""


Again, if I open the subform directly and eliminate the main form, the WHERE function works. Once I incorporate the main form back into the WHERE function, it fails.

Any suggestions?

Thanks

 

[ajetrumpet]

have you looked at BOB's FAQ on Subform references??

 

[zappa007]

Where can i find that?

 

[ajetrumpet]

http://www.access-programmers.co.uk/forums/showthread.php?t=127981