i have a Append query that works fine, within the criteria of the query
depends on a number that is on the open form.

This critiea workd fine [Forms]![frmManufactureTub]![HotTubCode]

Now instead of the looking for the number on the form i would like it
to look for the number within the subform within the form

I tried [Forms]![frmManufactureTub]![HotTubCode] but this does not work

do i have to change the criteriafor when i want ti to take a value from
a subform


Thanks

First, determine the name of the control on the main form that contains your
subform. (Depending on how you added the subform, it may be different than
the name of the form being used as a subform)

To refer to a control on the subform, you use:

[Forms]![NameOfParentForm]![NameOfSubformControl].Form![NameOfControlOnSubform]

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Simon" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>i have a Append query that works fine, within the criteria of the query
> depends on a number that is on the open form.
>
> This critiea workd fine [Forms]![frmManufactureTub]![HotTubCode]
>
> Now instead of the looking for the number on the form i would like it
> to look for the number within the subform within the form
>
> I tried [Forms]![frmManufactureTub]![HotTubCode] but this does not work
>
> do i have to change the criteriafor when i want ti to take a value from
> a subform
>
>
> Thanks
>