Query Criteria for a Subform

[hullstorage]

I have a query that i want to look up values from a subform
any ideas

my form is called FD
with a subform Called FDSubform and a field named JOBId

Basically after the subform shows me results from the main form
the query will look up the JOBId from the subform

at the minute i am getting in my query, this is what is in the criteria of the query under JOBId

[forms]![FD]![FDSubform]![JOBId]

invalid bracketing of name

 

[WayPay]

Try removing the brackets from [Forms].

 

[hullstorage]

Try removing the brackets from [Forms].

now i am getting

ENTER PARAMETER VALUE

FORMS!FD!FDSUBFORM!JOBID

any other ideas

 

[Rabbie]

Have you seen this link to Bob Larson's site.