How to refer to a subform properly...

[dragginthru]

Hey everyone

This issue is holding me back now on 2 areas of my project

I need to know correctly how to reference a subform in a query.

Can someone please give me a working example for this:


main form: training courses
sub form control: course_dates subform control
sub form: course_dates subform
text box: course_date


I have tried:

[forms]![training courses]![course_dates subform control]![course_dates subform]![course date]

in the criteria box, but every time the query runs i get a parameter box "forms!training courses!course_dates subform control!course_dates subform!course date" asking for the info.

Seriously I am totally stuck on this and i think all i need is one perfect example... please help!!!

 

[KenHigg]

Didn't I post a sample db with this in it from another thread?

 

[Crispy]

From memory:

[forms]![training courses].[course_dates subform].form![course date]

 

[dragginthru]

Didn't I post a sample db with this in it from another thread?

Yes you did mate, I did reply to the post that I still didnt get it. I failed to adapt your code correctly Also this is a slightly different one.

HOwever looking at the above example I see that there are .'s as well as !'s - i was only using the latter so thats probably the issue, just a grammatical one then!

Thanks all ill let you know how it goes