Subform Question

[hsdaguilar]

I would like to acces a a record in a form (frmPrimary) by entering a value
into a combo box (cboKeyword) in an unbound form (frmQuery), where the combo
box (cboKeyword) would match a text box (txtKeyword) in a subform
(subformProjects) within the form (frmPrimary).

I have tried
DoCmd.Openform frmPrimary,,,"txtKeyword=" &me.cboKeyword but it doesn't
work. (Perhaps because txt keyword is not in frmPrimary but in the
subform...)
I have tried
DoCmd.Openform frmPrimary,,qryProjects (where qryProject is a Query with
both the tblPrimary and tblProjects and the criteria for txtKeyword is
frmQuery.cboKeyword) but it doesn't work. It keeps asking me what
tblProjects.Keyword is.
I have tried
DoCmd.Openform frmPrimary (and then)
Forms!frmPrimary.Recorsource=qryProjects
This works, but then the subform dissapears. I'm thinking because the
LInkMasterFields is no longer to tblPrimary. But I can't figure out how to
set the value for that.

All of these have been on the on click event in an "ok" button.

Anyways... whatever way is easier is fine with me. I would just like help
with some code to get frmQuery to open frmPrimary using cboKeyword =
txtKeyword as criteria.

Please help!!!

Thank you.