Combo box not allowing data select and fill

[Guest]

Hell there,

I 'm creating a employee tracking database during some project down-time at
work and have run into a prolbem with a combo box.

Specifically, there is a form (call it 'Form' for simplicity here) with a
subform (Subform) that does a query from the entry in Form and displays the
data. The Subform query is linked to the control source for a Combo box on
Form, which we'll call cboctr1source.

When clicked, the combo box properly displays the two columns of info
beautifully. However, then you click on a row, it does nothing - the list
remains open until you take the focus off the combo box by clicking someplace
else.

Details:
- The combo box is linked to a query from the Project table that includes
ProjectID (key, column1) and ProjectName (column 2)
- The combo box Locked property is set to 'No'

What I've tried:
- I've tried using Bound Column 0 and 1, no change

Is there an On Key Down procedure that I must implement somehow?
Essentially this is what I want to happen: when the user clicks on the Combo
box the list opens (as it does now), user clicks on a value from the list
which, then the box closes and the ProjectID. This ProjectID is then used in
the subform query (this part s actually occurring ok).

What am I doing wrong or missing for the combo box to allow the user to
select a value (from the list ) and have that value update in the Combo box
display?


Your assistance is much appreciated. Thank you in advance.

John D.

 

[Guest]

Gosh I been here before but been while.

I think the combo box may just have an enternal problem.

Using the wizzard do it again. Then remove your subform and place it back
on the form liking it to the field in the subform you desire.

This will point to the right record every time you change the record in the
combo box if done properly.

If you actually use a query you have to place the
Forms!FormName!ComboBox.Column or FieldName in the query and then do a
requery after each event.

The pointing process works quite well in most cases..

Hope this is helpful..

Dwight

 

[Guest]

This worked great! Thanks a bundle.

-JD