Re: Not in list event

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I can do you one better

2003 verion
http://office.microsoft.com/en-us/workessentials/TC010184581033.aspx?pid=CL101211891033
if this link doesnt work, goto http://office.microsoft.com/ and in the
search box type "Inventory management database"

1) Download this database
2) Open this database
3) Double Click on the Category combo box and on the "Categories" pop
up form add "Cold Beverages" to the Category name
4) Close the "Categories" pop up form

This does not change the value of the category field on the Products
form. That would require some additional coding, but if you click the
Category drop down the value "Cold Beverages" does appear in the list.
This is the process I was trying to explain.

BTW the category combo box also has a not in list event.

John
MS Access Programmer
'Code Monkey'

<Note>
For an A2k version search Office.Microsoft.com for "Membership
Database".
1) On the main switchboard click "Enter/View Members"
2) At the top Click the Committees Command Button"
3) In the sub form Double Click on the Committee field and follow the
code.
<End Note>

On Tue, 2 Oct 2007 14:43:29 -0700, CD Tom
<CDTom@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

John, I can't seem to get the requery to work. When I'm back at the main
form it shows the new users name in the combo box but has the first user in
the database showing, when I try and click the new user in the combo box it
gives me the user not in list again. What other ways are there to accomplish
this.

"John" wrote:


I have noticed that when you open a form in dialog mode that the code
stops executing till the dialog form is closed. Then when the dialog
form is closed simply requery the combo box.

Example:
'open your master imput form in dialog mode
DoCmd.OpenForm " master input form", acNormal, "", "", , acDialog
'requery your combo box
Form_FormName.ComboBoxName.Requery

There are bout to be a dozen ways of doing this, but I have used this
same type of code at least a dozen times.

John
MS Access Programmer
'Code Monkey'


On Tue, 2 Oct 2007 08:29:01 -0700, CD Tom
<CDTom@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

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

.

Quantcast