combobox not working

[pbuethe]

My form has a subform on it containing what should be 4 identical subforms. This represents 4 columns on the corresponding paper form. The underlying query for each differs by the criteria for ColumnNo. Each of the identical subforms contains a combo box called cboEventAns. The subforms (both the form itself and the subform control) were created by creating the first one, then copying it 3 times and changing the record source, etc. appropriately. Yet of the 4 instances of cboEventAns, the original one does not work. It appears blank. When the drop-down arrow is clicked, the correct options appear, but the current value is not highlighted. If you try to select an option, #Name? appears in the combobox. I know there is a value in the field since I have a textbox which displays the description from the reference table, which is working for all 4 columns.

All the properties seem to be identical. What am I missing? Thanks for your help.

 

[llkhoutx]

Requery each subform on the afterupdate of the first combobbox.

#Name? indicates that you have an improper reference or field name relative to the underlying table.

 

[pbuethe]

Requery each subform on the afterupdate of the first combobbox.

#Name? indicates that you have an improper reference or field name relative to the underlying table.

Ilkhoutx, thanks for your reply.

I tried your first suggestion on the first subform's combobox and there was no change. For the second suggestion, since the other three subforms are copied from this one, the names are the same. Why would the copies work and not the original?

 

[llkhoutx]

Why would the copies work and not the original?

Maybe the surform's combo box's respective row source is incorrect. If's they're filtered, the filter could be incorrect.

Otherwise, can't tell from your posting.

 

[pbuethe]

OK, looking back at the underlying query for the form, apparently I had renamed the field in the 1st column query. I removed the renaming and then it worked. Stupid mistake! Thanks for your help.

 

[llkhoutx]

Simplest errors are often hardest to detect. Glad that you found it.

My experience is, show a "problem" to someone who knows absoilutely nothing about what you're doing and the error will immediately become evident.