A
Anita Taylor
In my Customers table, I have a list box lookup field to pull company name
data from another table. I have created a Customer Info form with a Subform
for the Company. I want the Customer area of the form to display the value of
the Customer table company field and the Company subform to display the
corresponding company information.
I believe I have it all working - except for correctly displaying ONLY the
company name for the current Customer record in the customer section of the
form. I get a combo box to display, but it lists all possible values with a
scroll bar. I ONLY want to see the exact entry selected for the particular
Customer.
Any help would be greatly appreciated! This shouldn't be so difficult, but
it's been tripping me up for two days now and I'm at the end of my rope!
data from another table. I have created a Customer Info form with a Subform
for the Company. I want the Customer area of the form to display the value of
the Customer table company field and the Company subform to display the
corresponding company information.
I believe I have it all working - except for correctly displaying ONLY the
company name for the current Customer record in the customer section of the
form. I get a combo box to display, but it lists all possible values with a
scroll bar. I ONLY want to see the exact entry selected for the particular
Customer.
Any help would be greatly appreciated! This shouldn't be so difficult, but
it's been tripping me up for two days now and I'm at the end of my rope!