Hello,
I have a subform called Journal Subform, with a combo box called cboContact_ID. The same subform is used on two different main forms. The two main forms hold company information, including a Company_ID.
I have VBA filling the combo box on the subform with the SQL statements, varied only by referencing the current main form name to get the COmpany_ID value, so that the combo filters for contacts only associated with that Company. The Got Focus event on the control runs the VBA. It works correctly.
The combo box itself has two columns: Contact_ID, which is the bound value, and Contact_Name, which should be displaying on the subform. The column width value is 0;1.75".
That may not have anything to do with the problem I see, in that (NOT ALWAYS), the name doesn't actually display. If I click in the field, it displays the Contact_Name for the Contact_ID value that's been recorded for that record.
I also have a split form that is just the complete Journal. All of the Contact Names display properly. So it's just on the subforms that the names are disappearing. I can't figure out why.
Hope you can help me. If so, thanks in advance!
MIB1019
I have a subform called Journal Subform, with a combo box called cboContact_ID. The same subform is used on two different main forms. The two main forms hold company information, including a Company_ID.
I have VBA filling the combo box on the subform with the SQL statements, varied only by referencing the current main form name to get the COmpany_ID value, so that the combo filters for contacts only associated with that Company. The Got Focus event on the control runs the VBA. It works correctly.
The combo box itself has two columns: Contact_ID, which is the bound value, and Contact_Name, which should be displaying on the subform. The column width value is 0;1.75".
That may not have anything to do with the problem I see, in that (NOT ALWAYS), the name doesn't actually display. If I click in the field, it displays the Contact_Name for the Contact_ID value that's been recorded for that record.
I also have a split form that is just the complete Journal. All of the Contact Names display properly. So it's just on the subforms that the names are disappearing. I can't figure out why.
Hope you can help me. If so, thanks in advance!
MIB1019