Query based on ComboBox selection

[pmac]

I'm trying to create a query that will run based on what is selected in the combobox. I have a main form which holds the subform with the combobox. I want a button to open the query. The query field references the combobox with [forms]![subFrmName]![cboName].



My problem with this comes when I press the button and I get a message box titled "Enter Parameter Value" with my field reference line Forms!subFrmName!cboName with a text box underneath.

Am I doing something wrong? I've checked the subform name and combobox name multiple times and it appears that I'm referencing them correctly.

[ketbdnetbp]

You could try -

[forms]![MainFormName]![subFrmName].Forms![cboName]

All the best,

Jim

[rpeare]

try forms!mainformname.subformname!fieldname

[pmac]

Thanks, I appreciate the help. I no longer have the annoying message box pop-up demanding a value. However, now I have another issue...

When I press the button my query pops up but it is showing other people in the database with the same combobox value when they actually have a different value. When I select another client he information is still there and correct, it is only when I press the query button that it shows different. Any suggestions?

[rpeare]

can you post a sample database with sample data. Access 2003 or below if you can.

[pmac]

mhmm sorry I can't do that.

When this query runs, other people in the database show up with the same info as what I have selected in the combobox. I want only those people who actually have that same value showing up.

[rpeare]

I can't guess without something to work with. The SQL code at a very minimum.

[pmac]

SELECT dbo_Table1.clientID, dbo_Table1.firstName, dbo_Table1.lastName, dbo_Table2.cName, dbo_Table2.optInStatus
FROM dbo_Table1, dbo_Table2
WHERE (((dbo_Table2.cName)=[forms]![frmMainScreen].[fsubCDetails]![cName]) AND ((dbo_Table2.Status)=[forms]![frmMainScreen].[fsubCDetails]![Status]));

[rpeare]

You're not providing a linking mechanism between the two tables that's probably why you're getting multiple results. There has to be some field your two tables have in commmon or you are going to get the number of items in the first table * the number of items in the second table (without adding criteria)

Link your two tables correctly in your query and your issue should disappear.

[pmac]

you're right, I got it now. Thank you I appreciate the help.