Add items to Combo Box isn't working

[Dave14867]

Hello all,



I have been working on a file for a while and I wanted to make it easier for users to Add items to combo Boxes on the fly and I cannot get it to work. If you open the frmAnimalDataEntry-Tabbed form try to select the "Breed" and add something that isn't there, it gives the error that the item isn't in the list. I thought I had everything set properly accorPets-11 Dave.zipding to videos I have seen but I just can't seem to get it to work properly. What am I missing

Pets-11 Dave.zip

Thanks
Dave

[mike60smart]

Hi Dave

The best method is to have a Command Button to Open a Form to add a New Breed.

Then when you reenter the Combobox it is Requeried to display the Breed you have just Entered.

See the attached

[Dave14867]

Mike,

I looked at the file you attached and I didn't see a command button added to the form

[mike60smart]

Hi Dave

My apologies I put the Command Button on the frmAnimalDataEntry.

I have now added it to the correct Form.

[Dave14867]

Mike,

I see what you did now, but I would like to use the built in functionality of Access if I can. I think it would be less cumbersome for users don't you?

Thanks Dave

[mike60smart]

Hi Dave

True but you will need to use a NotInList Event for Multi Fields which involves some knowledge

[ssanfu]

Here is my modification to the dB.
It uses the "Not In List" event of the combo box to add to the table "tblBreed" what was typed in to the combo box.

[Dave14867]

Steve,

That's what I wanted thanks for putting that in there. VBA is certainly not a strong suit of mine yet. Now I can incorporate that into other Combos.

Thanks again

Dave

[ssanfu]

Remember that you can use the "Not In List" event to open a form to add more data on more than control.

Good luck with your project...........