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

Listbox not updating

P: n/a
Hi - I have a form (frmMain), which has a tabbed control on it.

On the first tab, I have another form (frmChassis), on which there is a
listbox which is related to the current record by the [SerialNumber]
field.

The listbox has a rowsource of a query, which refers to the form as
[Forms]![Chassis]![SerialNumber].

This list box updates perfectly when navigating between records when I
just have the frmChassis form open - but when I open the main form (with
the tabbed control), and navigate the frmChassis records, the listbox
does not update.

Any help would be great, thanks,

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You have made the form Chassis a subform and to refer to subforms in a
Query you have to use this syntax:

[Forms]![frmMain]![Chassis]![SerialNumber]

Meaning:

<forms collection>!<main form>!<subform control>!<control on subform>
If that doesn't work try this:

[Forms]![frmMain]![Chassis].Form![SerialNumber]

Same thing as above, but explicitly indicates that Chassis is a
subform on frmMain.
HTH,

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQAgfRoechKqOuFEgEQJH6QCg3bJRSFxUmbiB8wwtcHjcnl 3dUYoAnAmH
kzVkNpLNP6iffaNT++g+hmH5
=yXDp
-----END PGP SIGNATURE-----
Mark wrote:
Hi - I have a form (frmMain), which has a tabbed control on it.

On the first tab, I have another form (frmChassis), on which there is a
listbox which is related to the current record by the [SerialNumber]
field.

The listbox has a rowsource of a query, which refers to the form as
[Forms]![Chassis]![SerialNumber].

This list box updates perfectly when navigating between records when I
just have the frmChassis form open - but when I open the main form (with
the tabbed control), and navigate the frmChassis records, the listbox
does not update.


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.