Access

[Kevin]

I'm creating a simple contact manager database.
2 tables here for simplicity.
tblContactInfo (you know name, adress, phone etc.)
tblContactType (friend, family, busness, student, coworker)

On the tblContactInfo table I have a ContactType field with a reltionship
to a field in the tblContactType Table

On the tblContactInfo form I would like to use a comboBox, I would like to
select an existing contactType or enter new contactType and have the new
record added to the tblContactType Table.
1) howI do I accomplish this and have the tblContactType Table updated
2) can I have the items in the combo box eliminated alphabetically as I
type each additional letter

Thanks,

Kevin

 

[Douglas J. Steele]

1. Take a look at http://www.mvps.org/access/forms/frm0015.htm at "The
Access Web" for how to add new items to the combobox simply by typing them
into the list

2. Make sure the AutoExpand property is set to True (Yes through the GUI)