List Items Edit Form on Property Sheet

[wilderfan]

I have an unbound combo box on a form which offers users a list of names to choose from.

I want users to be able to add new names to the list so I have filled in the List Items Edit Form on the property sheet of the combo box.

An icon now appears at the bottom of the combo box list which allows users to open up the other form in order to add the new name.

I would rather users key in the new name into the combo box field and have access prompt them to add the new name via the 2nd (other) form. This way, the new name appears in the original form's combo box field when the user closes down the 2nd form (after adding the new name).

In other words, I don't want users to be able to click on the icon to access the 2nd form. When users click on the icon, the new name does not automatically appear in the combo box field of the original form once the 2nd form has been closed down.

So my question is:

Can I eliminate the icon without losing the functionality of the List Items Edit Form property?

Thanks.

 

[vbaInet]

It can be done programmatically in the Not In List event. Search the forum for this discussion.

 

[John Big Booty]

...and here's a sample that demonstrates just that

Have a look at the Not In List event of the Combo on FRM_Records, and the On Load event of the FRM_Clients.