Using combo box for field list record selection

  • Thread starter Thread starter Julie Nicole
  • Start date Start date
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
 
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
 
Back
Top