Hey Rich
I'm one of your students with a question.  I've built a company form and have used several combo boxes in it but for some reason the combo box never asked me what information i want to store for instance i have a combo box for states the fields are stateid and stateabbviation and statename it never gave me the option on picking what i want to store the stateid, the stateaddviation, or the statename and when i run the form in form view everything works but i built a contact information form heres how i did that i made a table with contact information fields then i made a query table using both company information and contact information fields and built the for using the query table and when i use the form it is pulling information just from the id's the autonumber its not puting the information i want i thought would show from the combo example stateid is being put in to the contact form witch is number 13 not the state name which i want and all the combo box fillins are just showing the id autonumber how do i fix this?????

---

Reply from Richard Rost:

Normally, you only want to store the ID from that combo box in the underlying table. For example, if you have a StateID, that's what you want to store in your customer table. If you want to get additional information out of that combo box, you will need to do it with an AfterUpdate event, utilizing the .Column() property. However, you're better off just storing the ID and then using a linked query to get that information if you need it again in the future.