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
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