combobox in subform not working

[Guest]

I have a form with multiple subforms all interrelated by a common designator.
I have just added a new subform with a new underlying table. The other
subforms have code for "On Dirty". I have duplicated every aspect I can
think of from the original subforms as a template to the new subform. When i
try to enter something into the single combobox, the combobox is properly
populated, but when I select something, it just pings at me. I can't seem
to make the selection.

Any ideas why would be appreciated. TIA

Papa

 

[Roger Carlson]

Is the combobox bound to a field? Is the query that is the Record Source
for the subform updateable? Is there a message in the status bar at the
bottom of the screen?

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Roger,
I will attempt to answer your questions:
The combobox is bound to "column 1" and the row source is:
SELECT DISTINCTROW [Zlookup: Keyword].KeyCode, [Zlookup: Keyword].Keyword
FROM [Zlookup: Keyword] ORDER BY [Zlookup: Keyword].KeyCode;

I just figured it out - thanks it was improper control source