Hi all,
I've got two subforms on an unbound form, frmMain, frmSubOne, frmSubTwo.
Ive got a control on frmSubTwo, cboList, a list box, which draws its source
from the table underlying frmSubOne.
I want this list to be kept automatically up to date, for selection, so
after updating frmSubOne, the new records will be visible in the cboList box
when selected.
Here's what im doing, but it is giving inconsistent results.
on the CurrentEvent of frmSubTwo,
me.cbo.requery
me.refresh.
Think my problem is I don't fully understand how the current and activate
events work on a subform!.
As usual any advice / guidance most welcome.
Gerry Abbott
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.518 / Virus Database: 316 - Release Date: 11/09/03