Listbox not updating

[Mark]

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!

[MGFoster]

-----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.