macro vs. vb question for open form

[kelsita_05]

Hi-
So I currently have a simple form, in which you select a persons name from a combobox, click OK, and it brings up all their records with a query. Shows up in datasheet view and it works just fine. However, it would be much more user friendly/easy to see if I could have it present that information in form view (the form is called frmFindFeedback). I tried the OpenForm macro with the query as a filter, but then you have to type in the parameters, rather than selecting it from a combobox.
I'm pretty sure this can be accomplished with VBA. here's the code that I have on my name selection form:


Private Sub cmdCancel_Click()
DoCmd.Close acForm, "frmSearchforfeedback"
End Sub

Private Sub cmdOK_Click()
DoCmd.OpenQuery "qryfeedback", acViewNormal, acReadOnly
DoCmd.Close acForm, "frmSearchforfeedback"
End Sub

Pretty simple, and I just can't quite make the connection for how to get it to show it in a form.

Thanks for all your help!

 

[kelsita_05]

Works beautifully!
Thanks for helping me straighten things out!