using a Combo Box to get data to open another form

G

Guest

I need help with using a Combo Box to get data to open another form. On my
“Main Switchboard†form, I have a combo box “FindGroupâ€, where I can pull
down “IndSmallgroup†and then go to a form for editing called “Small Groups
Input/Editâ€. But when I pull down a value for “IndSmallgroupâ€, rather than
going directly to the editing form, I get a window asking to “Enter Parameter
Value†showing the selected value for “IndSmallgroup†above the input window.
If I then type in the desired “IndSmallgroupâ€, I then go to the editing form
for “IndSmallgroupâ€. I've tried various codes but always get the "Enter
Parameter Value" window; I want to go directly from the combo box to the
editing form. Can anyone help?
Thanks,
Chris
Here’s the code I’m currently using for the On click property of the combo
box:
Private Sub FindGroup_Click()
Dim stDocName As String
Dim stLinkCriteria As String
stLinkCriteria = Me.FindGroup

stDocName = "Small Groups Input/Edit"
DoCmd.OpenForm stDocName, , , "IndSmallgroup=" & stLinkCriteria

End Sub
 
G

Guest

I found a reference to a Module 1, that I know nothing about. Could this be
causing the problem?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top