-----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:[color=blue]
> 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.[/color]
