Combo Box Column Display Issues

  • Thread starter Thread starter Herb
  • Start date Start date
H

Herb

I am populating new records in VBA code. One column is a lookup of MbrName
from another table. In the VBA code of the form that adds the record, I
populate that table column by Me.MbrName = Me.unboundformfieldMbrName, which
uses the same combo box. After the form is closed, the correct MbrName
appears in table. However, when subsequent form controls display this field
(as a Combo box), the field shows as blank. If I open the table and select
the same MbrName that is showing, then somehow it "takes" and subsequent
forms display the MbrName appropriately. What might I be doing wrong here?
Thanks so much. HJ
 
Make sure in the combo's properties that

Number of Columns

and

Column Widths

are set. If you have 2 columns but the number of columns is set to 1 it
won't show the second column.

--
Bob Larson

Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________
 
Thanks, Bob. The column count and width properties seem to be in order.
When I actually click on the combo box to bring up the list it works
perfectly in terms of displaying the proper values. The problem relates to
displaying the value that was inserted into the table on a prior form. HJ
 
Problem solved. The problem was in my VBA program. It was populating the
MbrName column with the text string of the name, rather than the column
(MBRID) that was the bound column.

Thanks. HJ
 
Back
Top