Combo Box

[Rockin-John]

Hi,
Information Please, is it possible to have a combo box with a drop down menu and if an item is not listed, to be able select new record within the combo box, and have it stored and displayed. If so how I do I go about it.

Thank you in advance.


John

[RuralGuy]

Is this what you are talking about? http://www.fontstuff.com/access/acctut20.htm

[Rockin-John]

It does look like what I want, but I cannot limt the list, because of the column widths being 0cm:3cm if I change these the ID column shows. all I want to do is:

Select item on the list
If item is not on list, type it into combo box,
and if possible save to the list.

hope I have Made it clearer

Again Thank you

[Rockin-John]

Hi,
Thank you Rural Guy have resolved issue, another query if you do not mind, I have created a table which has ten items & cost columns and one for total cost. these have been made to display on an invoice sheet on a form. this is the only way I could see of acheiving it, as I know very little of access is this method right or wrong ?.
I will on your response goto the resolved link.

Again Thanks

[RuralGuy]

If what you are saying is that there are 10 item and cost fields in each record then the answer to your question is NO! These should be in separate records.

[Rockin-John]

Hi,
one table consisting of 10 Item field columns & 10 Cost Field columns with one for total cost:
item01|cost01|item02|cost02 etc.

[RuralGuy]

You are violating Normalization rules here. I would strongly suggest you brush up on Normalization before proceeding any further or you will leave yourself open for grief in the future.

[Rockin-John]

I will brush up, thanks for solving original question.

[RuralGuy]

You're welcome and good luck.