How to store values in a Combo Box

[hawkeye71]

I have created a FORM in Access 2000.
The FORM is built using ONLY one table.
I have 3 fields defined as combo boxes.
What I Want:
I enter the data in the fields(combo box) and if I go back, I do not have to retype the data, if I click on the drop down, I should be able to see the data or if I type the
first three letters the particular entry comes up in the combo box.
I have tried to use the Row Source Type and Row Source properties for each combo box
field.
The problem I run into, that for each combo box, the data it shows is the data in the first combo box.
How can I define such that the combo box only lists the values entered into it previously.
And this should be updated as I add each record, without exiting the form.


Thanks,
Indiana

 

[dhookom]

Combo boxes should not be used in table designs. Combo boxes can/should be used on forms and their row source should be a table or query.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.