F
FirstVette52
The code for my form's Combo box [Combo_CompanyID]'s Select statement is:
SELECT Company.CompanyID, Company.Company
FROM Company
ORDER BY Company.[Company];
....but when I use the standard format to set a text field equal to the Combo
box control
=[Combo_CompanyID].[Column](1)
to get the value in Column 2, I keep getting a '#Name?' error. When I enter
=8+8 I get 64, but if I try to set the field equal to any field on the form,
I get the '#Name?' error.
Any ideas will be greatly appreciated
SELECT Company.CompanyID, Company.Company
FROM Company
ORDER BY Company.[Company];
....but when I use the standard format to set a text field equal to the Combo
box control
=[Combo_CompanyID].[Column](1)
to get the value in Column 2, I keep getting a '#Name?' error. When I enter
=8+8 I get 64, but if I try to set the field equal to any field on the form,
I get the '#Name?' error.
Any ideas will be greatly appreciated