You are here:

Using MS Access/Combo Box suddenly stops working

Advertisement


Question
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  :)

Answer
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,
Scott<>

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Scottgem

Expertise

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

Experience

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

Organizations
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

Education/Credentials
Brooklyn College BA

©2016 About.com. All rights reserved.