[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Can't select from combo box?

Posted on 2008-09-30
3
Medium Priority
?
978 Views
Last Modified: 2013-11-28
I've got a combo box whose RowSource is set in VB, as the contents differ based on the calling parameters for the form.

The combo box is populated with the correct values,and I can pull it down and highlight a value, but clicking on the value does nothing.  The value can not actually be selected.

The properties are identical to those for all our other combo boxes, and the form properties look fine as well. I haven't seen this one before......any ideas would be appreciated.

Thanks!
Lynne
0
Comment
Question by:L_Malchiodi
3 Comments
 
LVL 10

Expert Comment

by:calpurnia
ID: 22609280
The most obvious cause I can think of for this kind of behaviour is if the Locked property of the control is set to Yes, but from what you've said, this doesn't apply in this case. Any chance of uploading a sample version of your db?
0
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 22610372
Do you have any code running in the AfterUpdate or Change (or other) Events?

This could also be caused by an incorrect RowSource and Bound Column settings ... in most cases, the Bound Column should be 1, and the RowSource should include the PrimayKey value of the underlying recordsource in the FIRST column place.
0
 

Author Closing Comment

by:L_Malchiodi
ID: 31501721
Thank you!  The Row Source and Bound Column settings had been changed.   After correcting that, I can select from the combo box again.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question