Combo Box Form Entries

[rmdrye]

I have three combo boxes set up so that after an entry is made in the first, the second requeries and displays only pertinent information. The third does the same to the second. They are bound to fields in my Orders table. The problem is the info being entered into the fields on my order table is different than the selections made in the combo boxes? Could anyone explain to me what is going on....Thanks, Bobby

 

[Jack Cowley]

If, for example, you have two columns in your Combo boxes and the first column is an ID number (normally hidden) and the second column is a Name, what you will see in your combo box is the Name but Access will save the ID to the table. The bound column in the combo box is set to 1. If you want to save the Name to the table then change the bound column to 2. Be sure that what you want to save in the table is the Name and not the ID. If this does not clear up your problem then you will need to supply more details on the design of your combo boxes.