Combo Box list not populating Control

[CC234]

I have a problem that is driving me up a wall!!

I've built a form with a variety of (12 or so) command buttons. Each command button has the name of a facility on it (the caption) which is used as the criteria in running a query. From this query I can produce a report containing general information about each facility. That part works great.

So I press the command button on this first form; another form opens that has the name of the selected facility in a text box (from the caption on the previous screen/form)and another command button to run the general report.

I also use the same criteria in a query used as a record source for my combobox for viewing detailed information This part works fine also, however when I try to select a record from my drop down list it will not populate the control.

I should add that I've tried building the combobox from scratch and by using the wizard, with the same result. If I build a different form that isn't getting information from previous form selections the combobox function works fine.

Any suggestions???

Thanks for any help that you folks can give..

 

[ProgramError]

If you have more than one field in the combobox are you sure you are using the right field?
What is the record source of the 'control' and what is the control? a text box? a button? another list?

Ian Mayor (UK)
Program Error
If people say I have bad breath, then why do they continue to ask me questions and expect me to answer them?

 

[CC234]

The record source of the control is an SQL statement with the where condition being the same criteria that I'm using for the report. I did just notice that if I don't select the criteria programmatically, and instead type in a parameter it seems to work.

SELECT tblName.[ID Number], tblName.[ID Name], tblName.SITE, tblName.[Facility], * FROM tblName WHERE (((tblName.[Facility])=[Forms]![frmFacilities].[ActiveControl].[Caption]));

I have 3 fields in the combobox. The 'bound column' is the first column. I've tried using '0' and '1' as the bound column property.

Thanks..
CC