Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Combobox Value Will Not Change - Until I Right Click?

0 views
Skip to first unread message

rlm

unread,
Nov 25, 2009, 9:22:02 PM11/25/09
to
Not certain how to describe this one. A combox is placed on a form.
The form is called from a continuos list via a mouse down event.

If Button = acRightButton Then
DoCmd.OpenForm "frmTask", acNormal
End If

The form, frmTask, has absolutely no code behind it. It has a combobox
with a row source type of "value list" and a row source of
""Complete";"Complete with a Problem";"Abandoned"".

The form, frmTask, is set to allow edits, allow additions and allow
deletions all = yes.

The value in combobox cannot be changed... until the user right clicks
on the combobox.

!?

What am I missing?

Crystal (strive4peace)

unread,
Nov 28, 2009, 6:39:08 PM11/28/09
to
do you have the extra quotes around the RowSource or did you
just put them for this post?

what are the following properties:
ControlSource -- and data type of bound field
ColumnCount
BoundColumn

What is the RecordSource of frmTask? If it is a query, what
is the SQL for the query?

Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
(: have an awesome day :)
*

0 new messages