Re: Not in list event
- From: "Arvin Meyer [MVP]" <a@xxxxx>
- Date: Mon, 8 Oct 2007 13:50:38 -0400
I see you still haven't resolved your issue. Using the Access constant WILL
resolve it. I also have some generic code at my website:
http://www.datastrat.com/Code/NotInListCode.txt
You will notice that the Response argument in the NotInList code uses:
Response = acDataErrAdded
That Response argument is there for a reason. Requerying will not help if
you do not use it.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
"CD Tom" <CDTom@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5BDE4B9A-6A2F-41C6-81BC-B2D5237EFDA4@xxxxxxxxxxxxxxxx
I have a combo box that is set for a not in list event if the customer that
the user types in isn't in the current db. When the not in list event is
entered the user is presented with a message if they want to add the user?
If they respond yes the I bring up the master input form. The user then
fills out the form and then exits, I'm back at the original form but the
new
customer isn't available to display, if I exit the form and then reenter
it
the new customer is there. What I would like to have happen is when the
user
leaves the master input form the new customer is displayed on the original
form. How do I make this happen. Thanks for any help. I always get
great
answers here when I'm stumped.
Tom
.
- Prev by Date: Re: How do i put my photo from my document to my emailbox or internet
- Next by Date: Re: combo box display format
- Previous by thread: Re: Not in list event
- Next by thread: Re: drop down list stopped working
- Index(es):
Relevant Pages
|
