Items in ComboBox

H

Henny

In a database I have a combobox with a few items. When a I try to add a new
Item in the combobox an error occur "The name is not in the database"
Who can help me to solve this problem in VBA ..?

thank you

Henny
 
L

Larry Linson

In a database I have a combobox
with a few items. When a I try to
add a new Item in the combobox
an error occur "The name is not in
the database"
Click to expand...

(1) Are these items a Value List or do you have a Row Source bound to a
Table or Query? (2) How is it that you are trying to add the new item that
results in this error message?
Who can help me to solve this
problem in VBA ..?
Click to expand...

I'm sure there are many here who might be able to assist, with enough
information.

Larry Linson
Microsoft Access MVP
 
S

Sharkbyte

Henry:

Larry is right, in his questions, however, I am going to take a stab at this
as I think I know what you are trying to do.

I believe you are trying to add a new value, to a list you are displaying in
a combo box. If this is the case, then check the 'Limit To List' property,
of the combo box. You would want it set to "No". If this is not the case,
then you should provide more info, as Larry suggested.

Sharkbyte
 
H

Henny

Dear Larry and Sharkbyte
Thank you.
I'm trying to add new values via a form in what the combobox is part of. I
have the values (in this case what is written about software as for instance
Windows , access, excel etc.etc.. The values are windows, access and so on)
when I see in a magazine something about antivirus and this value is not yet
in the table I want to enter this value in the general input form .
Is this more clear ...?? or ,....?
Henny
 
Top