You are here:

Using MS Access/Combo Box suddenly stops working


Hi Scott,

First of all, thanks so much for your help.  I have a couple of questions..

First, I have a combo box that is on a main form that also has a subform.  For no apparent reason the combo box stops working.  I will select a value from it, and it won't find the correct record in the subform.  It can find the record numerous times, then all of a sudden nothing.  Any ideas?

Also, the values in this combo box have an input mask that is set on them in the underlying table and also in the combo box itself.  The values don't always appear as they should in the input mask.  They appear perfectly in the table, but not in the combo box.  Any ideas on why this is?

Thanks so much for your help.  I really appreciate it.
Carla  :)

First, Input masks only apply to text fields. If you use a combobox, you have to format the selection in the RoSource of the combo.

Second has to why a selection doesn't always bring up matching records in the subform, may be an issue of the input mask. The data may not be stored the same. I would have to see the RowSource and bound column of the combo and the Recordsource of the subform with sample data

Hope this helps,

Using MS Access

All Answers

Answers by Expert:

Ask Experts




I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.


I've been designing databases for over 25 years working with dBase, FoxPro, Approach and Access.

Author of Microsoft Office Access 2007 VBA
Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing

Brooklyn College BA

©2017 All rights reserved.