Look Up Values, where you can also set your own.

[emdiesse]

How can I create lookup values where I can also click other and type my own in the same box, would this be VBA in the form rather than stuff in the table?

 

[RV]

If you're referring to lookup columns in a table, don't use them if the lookup values are not static.
Define separate tables instead and maintain them through forms.

An example of static data is gender, as the existing values are predetermined and will never ever change.

RV

 

[emdiesse]

If you're referring to lookup columns in a table, don't use them if the lookup values are not static.
Define separate tables instead and maintain them through forms.

An example of static data is gender, as the existing values are predetermined and will never ever change.

RV

Well, i am using a Mr, mrs thing but I was planning on entering Mr, Mrs, Miss, Ms as the main ones and then they can type in other ones such as Dr, Sir, whatever they may be.

 

[Rod D]

I absolutely agree with RV.

If you intend to have what is typed into the combo-box displayed in the drop-down at a later stage, then you have to save it to its' own table. If you don't mind typing "Dr", "Sir" each and every time in the future, then ...

...you can set the "LimitToList" property to "No", which will allow you to enter your own values into the Combo-Box and this will be saved to the field "Control Source" for later use - queries / reports / etc.

I would still recommend RV's approach as it gives you better control over the data, with the overhead of one small table and an update form. I think it would be a small price to pay.