Apr 24 2008, 05:20 PM
I have a form to enter construction project information. When I get to the combo box for an Architect and find that the Architect I need for this project is not in that table, I go directly to the "architect entry form" and enter the architects data so that it will show up in the combo box now and in the future.
The only problem is that even though I have a save record command button in the architect entry form, I cannot go directly back to the construction project information form and select that newly entered architect unless I close totally out of everything except my switchboard and go back into the project info page.
Is there someway to make it instantaneous so that I don't have to go through this pain.
Thanks in advance.
Apr 24 2008, 05:22 PM
Take a look using the Advanced Search upper left corner and type in Not In List Event if you have a problem locating etc. let me know
Edited by: jmcwk on Thu Apr 24 18:22:55 EDT 2008.
Apr 24 2008, 05:26 PM
I did it but I don't know what I am looking for.
Apr 24 2008, 05:35 PM
Try looking up "Not In List" in Access Help. Maybe you'll have better luck there. Just my 2 cents...
Apr 24 2008, 05:42 PM
Ok, I have looked through 200 answers and none pertain to what I am doing. Any more help?
Apr 24 2008, 05:43 PM
Apr 24 2008, 05:55 PM
Nice link, John.
Apr 24 2008, 06:12 PM
Open the Attachment and enter a Name in the Main Form
Then open the main form in design view,
double click on the Combo and the Property window will open.
click the Event Tab
scroll to the On Not in List [Event Procedure]
click the ... to the right
What you see is the Code used to open the the other form to add the Name
Apr 24 2008, 07:37 PM
If your current set-up does not use the Not-In-List Event (which your description indicates so), you need to re-query the "Architect" ComboBox in construction project information Form after you add the new Architect in the architect entry Form.
Use the architect entry Form_AfterUpdate Event to re-query ... You may also need to flush the cache to ensure that the new Architect is actually saved in the Table (and not in the cache) before re-querying.
Apr 25 2008, 08:41 AM
Thank you everyone. The Re-Query was the key!
Apr 25 2008, 11:36 AM
You're welcome ... Glad we could help ...
May 15 2008, 09:02 AM
So I thought Re-Query was the key. It works sometimes and sometimes is doesn't. I am requerying "after update" and also "on insert".
Some of my coworkers are not getting the same performance of the requery I am getting. My first thought that the requery was specific to my computer. After a check, I see that is not the case. I also thought maybe these individuals memory was enough to "quickly" show the results of the architect information when they go back to the project entry form and see the architect entry in the drop down. Confusing! Any suggestions?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here