combobox in the form

[vicgirl]

Hi everyone,
Many may have seen this problem before. This is the re-post of "Another combo box problem". However, in order to explain more clearly, I have attached the sample db.

My supervisor asked me to do a combo box which can auto-complete the third column when the first column is enterred.

In this case, I have a combo box called File in Log Entry Form, which saves all the file names to the File field in the Maintable.
The source type of this combo box is Table/Query. It gets the file names from FileList Table, including Drawer, Classification, Sub-Classification(this is the file name) three fields. Since the FileList table includes lots of records, it is very convinient that when the Drawer field is enterred, it can automatically fill the sub_classificationto the 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 solve 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!

 

[Rusty]

I've had a quick look at the database and have carried out the following:

1. Gone into the relationships screen and delete the relationship between the two tables. You don't need this and it's incorrect I'm afraid.

2. Gone into the design of the "Main Table" table and change the "file" field to a Text Box, and then change the Field Size to 255.

3. Gone into the form design of "Log entry form" and created a pick list above the “file” field. This displays the “Drawer” field but returns the “Sub classification” data to the “File” field on the form and the table.

I’ve had to do this because on the form because the bound column is not the first visible column and Access gets twitchy when this happens so I’ve used this method in the past and bypassed it. Others may read this post and scream in horror at this , but if there’s a simpler way guys of displaying the returned value on the form, rather than the first visible column, then please let me know.

==========================================================
I've done all this to your original attached database and it works fine, but I would suggest getting rid of the On Open Event on the "Log entry form", which I have done. It's a pain if you want to look at existing records and can lead to new records being added by mistake. You could always add a bloody big "Add Record" button to the form and guide (and educate) your database users. I find a cattle prod normally helps!

Cheers,

Rusty