combo box selection - information is not being retained

M

Marney

HELP!!!!! I'm getting driven crazy!!!


I have been developing a form based on a query. I have been requested that
combo boxes be used to select some of the information.

However, once in the form what I select from the combo box is not retained
and not entered on the sheet. When I go through all my records all that is
retained is the last selection that was made in the combo box.

I have asked many people and no one knows what is going on.

What am I doing wrong? Please enlighten me :)
 
R

Rick Brandt

Marney said:
HELP!!!!! I'm getting driven crazy!!!


I have been developing a form based on a query. I have been
requested that combo boxes be used to select some of the information.

However, once in the form what I select from the combo box is not
retained and not entered on the sheet. When I go through all my
records all that is retained is the last selection that was made in
the combo box.

I have asked many people and no one knows what is going on.

What am I doing wrong? Please enlighten me :)
Click to expand...

Sounds like the CombBos is not bound to a field in the table. What do you have
in the ControlSource property?
 
J

John Vinson

HELP!!!!! I'm getting driven crazy!!!


I have been developing a form based on a query. I have been requested that
combo boxes be used to select some of the information.

However, once in the form what I select from the combo box is not retained
and not entered on the sheet. When I go through all my records all that is
retained is the last selection that was made in the combo box.

I have asked many people and no one knows what is going on.

What am I doing wrong? Please enlighten me :)
Click to expand...

Please post the SQL view of the query upon which the form is based;
the RowSource property of the combo box; its Control Source; and its
Bound Column. One or other of these is evidently wrong!

John W. Vinson[MVP]
 
Top