Solved

Refresh combo on 1 form as results of updating another form

Posted on 2012-12-21
2
370 Views
Last Modified: 2012-12-21
I am drawing a blank here - where is the best place to place the Requery/Refresh - when I update the list of a combo on 1 form I want it to be displayed in the combo on another.

FormA.SubForm1.Combo1 - list of Assignment Types to be assigned to a specific Organization.

FormB.Subform2.combo2 - List of Assignment Types - Need to add to the list that will be displayed on FormA.SubForm1.Combo1

I have tried the refresh on the load of the Subform1, on the Load of FormA,
OnClick of the Combo1, on BEforeUpdate - all without success.

Please help,
K
0
Comment
Question by:Karen Schaefer
2 Comments
 
LVL 22

Accepted Solution

by:
Kelvin Sparks earned 500 total points
ID: 38714325
On the form after update of form 2 create an event that has

Forms!FormB!Sunform2.Forms!Combo2.Requery


Kelvin
0
 

Author Closing Comment

by:Karen Schaefer
ID: 38714394
thanks for the assist - ended up placing code on close of the forms - works great.
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

706 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now