Using combo box for field list record selection

J

Julie Nicole

Hi,

I have a form and one field I have used the wizard so it will bring up the
records in a field in a table. I like the forms this way so I can check
first to see if a record is already there or not.

Problem is, when I use the down arrow and see the entries, I can only select
them. If the record is not there and I need to enter a new one I cant. I
have looked around and tried things like checking "limit to list" as "no"
but that then gives an error on a colum size (default under colums is 2 but
I only need one and dont understand why 2 is the default) so when I change
the column size on the first column which default is 0, it then jumps to the
first column and gives a number and I still cant enter manually if its not
in the drop down box.

Is there a way where you can have a combo box show the list where you can
select an item but if its not there you can enter it manually?

thanks
Julie
 
J

JulieD

Hi Julie

if i'm understanding you correctly have a look at
http://www.mvps.org/access/forms/frm0015.htm
Add item to combo box using OnNotinList event

this is used to add a new option to a combo box if it is not in there (e.g.
you have a combo box of favourite colours - consisting currently of red,
blue and green and my favourite colour is purple and you want to add it (and
use it in other records) . .then the above code should provide the method
for you).

Please post back if you require further assistance.

Cheers
JulieD
 
Top