By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,940 Members | 611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,940 IT Pros & Developers. It's quick & easy.

Updating recordset for a subform

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
False alarm, Problem solved.

I found the cause, and it was not related to the forms, but relationships
which i had set up between the underlying tables. The tables were connected
with an inner join with data integrity set. I replaced this with an
appropriate outer join, and all is well now.

Gerry Abbott


"Gerry Abbott" <pl****@ask.ie> wrote in message
news:ru****************@news.indigo.ie...
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

---
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
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.