Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Parent drop-down refresh after change on child form

Posted on 2012-04-04
2
Medium Priority
?
395 Views
Last Modified: 2012-04-10
I have a parent/child form.  On the parent form is a drop-down listing all the active employees.  On teh child form is a control that the user can enter termination date.  When the date is entered, the underlying record is updated and everything works fine. However, how do I get the parent drop-down to refresh so it does not show the terminated employee?  This is an ACCESS 2003 database.

(BTA, this is a different database from two other open questions for those who are helping me with those questions)

Sandra
0
Comment
Question by:ssmith94015
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 37807312
place this code in the subform control afterupdate event

me.parent.comboName.requery
0
 

Author Closing Comment

by:ssmith94015
ID: 37829642
Yes, I was missing the parent part of the statement.

Sandra
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question