Cmd Button in Forms - Open blank form

[PAJ2]

Greetings.

I have created a new form and I would like to add a button that would let me open a new window with a different blank form.

For example, I have a form called inquiry and there is a field for "contact." If the contact is not listed on the drop down list I created from a linked table, I would like the user to be able to add data on the new contact and then go back and choose that contact from dropdown box. In the existing dropdown, I concatenated the contact so it lists the contact name and and associated organization.

I did this about 15 years ago so my Access skills and memory have seriously deteriorated. I think I need to add a Me.Refresh but I am sure other things are needed in the code.

Thank you in advance for your help.

PJ

[pbaldy]

I'm not clear on where you need help. Once the contact is added via the other form, you'd want to requery the combo box on the first form.

[Bob Fitz]

Should be able to do that using the Not In List event of the combo box. Lots on google etc. See: https://learn.microsoft.com/en-us/of...obox.notinlist
post back if you need more help with it.

[KNicholson]

Fortunately, MS Access has made this easy now.
Without any coding, on the contact field, just put the form name of the form that you maintain your contacts.
Eeek! They automated not-in-list.

It is the "List Items Edit Form" on the properties sheet under data.

[PAJ2]

Hello.

Thank you for your help. I can find the "List Items Edit Form" in one form but not another.

If I add a contact within that, add an organization, the organization refreshes but not the contact name. The contact name is concatenated. If that part of the problem?

Thank you.