469,601 Members | 2,272 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,601 developers. It's quick & easy.

Opening an external Access form to add record (not-in-list event)

My form contains a combo box and the "not in list" event is triggerred when
the user enters a value that is not among the values listed in the combo
box. I want the user to be able to add a new value (which is fairly easy to
do) but here's the twist...

The form that allows the user to enter the new value exists in a separate
Access database. I would like to open that form (modal), allow the user to
enter the new record, close the external form, and update the values in my
combo box to include the new record the user has just added.

Is this possible? If so, can anyone point me to a resource that can tell me
how to do it?

Thanks!
Todd

Nov 13 '05 #1
1 2259
Todd, are you using linked tables from the database you want to open? Are you populating your
combobox from one of the linked tables or a query based off of one those linked tables? If so why
not just import the form to your app and run it from there.

Just a thought cause I'm not sure exactly what you're trying to do.

--
Reggie

----------
"Todd" <to**********@penland.net> wrote in message news:zf**************@fe25.usenetserver.com...
My form contains a combo box and the "not in list" event is triggerred when
the user enters a value that is not among the values listed in the combo
box. I want the user to be able to add a new value (which is fairly easy to
do) but here's the twist...

The form that allows the user to enter the new value exists in a separate
Access database. I would like to open that form (modal), allow the user to
enter the new record, close the external form, and update the values in my
combo box to include the new record the user has just added.

Is this possible? If so, can anyone point me to a resource that can tell me
how to do it?

Thanks!
Todd

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.