Forms, Combox Edit List Option

[RoundTrip]

Alright guys! So I have a few different combobox's where the people entering the information in the form, will every now and then have to add a new item in the dropdown box, for example they will be entering chemicals and if they so happen to use a new chemical this week, they will edit the list on the combobox to the list. Well I just did the editing last week on the list box to make sure everything worked but now it seems, every time I go to the property list for combobox in the form and click the choice on the List Items Edit Form, and then go back to Form view and choose the edit list option the pop up to add to the list does not come up? What am I doing wrong exactly? Did I corrupt something? Or is there something I am missing?Thanks everyone in advance


If I have to post my database for more clarity please let me know, thanks everyone
And I have allow edit list box checked yes, I made sure to check that :P

[June7]

Sounds like the source of combobox items is a Value List. I recommend you have a table of chemicals as the RowSource. Add a new chemical by adding a new record in the table. This can be done on-the-fly with the NotInList event.

http://www.blueclaw-db.com/access_no...ed_example.htm

http://www.fontstuff.com/access/acctut20.htm

[RoundTrip]

Alright thankyou june, I like how the first one looks, I am about to try to get that to work for me, let me see if
I can get it to work by changing the things I need to and then if I can not I'll follow up by asking questions.

[RoundTrip]

Ok, I am sorry oin the first link, I really like that but in my events where would those go? I suck at coding im sorry just really confused about all that

[June7]

I don't know your db. You will have to adapt the code by using your object and control names. The events used are shown in the procedure declarations. NotInList for the combobox and a button Click on the add record form.

There are many tutorials on the web regarding NotInList. I provided two. If you need more guidance, search web. Post attempted code for analysis if you still have issues.

[RoundTrip]

Question? Could I not do a lookup field, and restrict the people from adding anything new without pressing the pretty little edit button at the bottom of the form? Make/ sense?

[June7]

Yes, you can go that route.

Code in the combobox BeforeUpdate event could do the Lookup and if value not found, cancel the update, set the combobox to null, give the user a popup message about the add record button.

[RoundTrip]

Thankyou, that worked amazingly, I am just not skilled enough to do the coding part, it is very difficult for me and I just need this to work, not really be just simply drop dead amazing, I appreciate this! Solved!