By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,837 Members | 1,357 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,837 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.