OnNotInList

  • Thread starter Thread starter 123
  • Start date Start date
1

123

Thank you for your help and answer:
I have combobox (NOT BOND) I want easy code to add value to the (VALUE LIST)
after update with out any msgbox..
thank you
 
Dear Sir



Mr Graham R Seach

Thank you For your help and answer

I read your answer it is very easy and you explain it excellent thank you

but I don't know it is not work with me I have apply every

property

limit to list = true

row source type = value list

the code is

==================================================

Me.Combo0.RowSource = Me.Combo0.RowSource & ";" & NewData
Response = acDataErrAdded

=======================================
the problem is the value not save in my combo when the form close and open
again (I think the wrong in access it self)

and also put any value in same line of combo box not in new line
 
If your RowSourceType is set to "Value List", you would need to save the
changes to the form in design view to make the addition permanent. This is
not something you can do in a data editing session.

Value List items are not really intended to be added to permanently. If
you'll be adding to this list from time to time, I suggest you create a
table to contain these values, and have the combo get its data from there.

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia
 
The link is exactly what I needed too. I was looking for a solution to the same issue, but: I need you to go one level back. When I put in "Dim db As Database", it says "User defined type not defined". I am obviously clueless here, perhaps I have to define a Database object somehow. Please help.
 
Chakey,

You have a missing reference.

1. Open any code module.
2. From the Tools menu, select References. The References dialog is
displayed.
3. Scan the list for the word "MISSING". If you find it, untick the checkbox
it relates to.
4. Then locate Microsoft DAO 3.x Object Library, tick its checkbox, and
click OK.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html


Chakey said:
The link is exactly what I needed too. I was looking for a solution to
Click to expand...
the same issue, but: I need you to go one level back. When I put in "Dim
db As Database", it says "User defined type not defined". I am obviously
clueless here, perhaps I have to define a Database object somehow. Please
help.
 
Back
Top