Another combo box problem

[vicgirl]

Hi,
I have another combo box problem.

I have a combo box called FileCombo, which saves all the file names to the field called FileName in a Table1.
The source type of this combo box is Table/Query. It gets the file names from a table called FileTable, including Drawer, Classification, Sub-Classification(this is the file name) three fields. Since the FileTable includes lots of records, it is very convinient that when typing the first few letters of Drawer field, it can go to the corresponding record and save the file name in this combo box . However, the problem I have right now is that the Drawer field is saved instead of Sub-Classification. Is there any way to fix this problem?

The source of this combo box is
Select Drawer, Classification, Sub-Classification from FileTable

and I have set the Bound Column to 3 .

Thanks a lot!

 

[Len Boorman]

Assumptions

Your form is based on a query that references a table
Table is Called Table 1
Form is called Form 1
Combo is called cbo 1

Think that you need to set the control source of cbo 1 to the name of the field in Table 1 in which you wish the value to the bound column to be saved

Len B