Subform Queries

[duns]

Hi Everyone,

I have a subform in a form and I have linked the child and master fields with the same field. Now what I want to do is reference the child field in a SQL query

i.e. SELECT * From students where students.familyid = subform.familyid but I can't seemt to get the system to do it.

I am using an Access 2000 project connected to a SQL Server 7.0 backend. Any advice on setting up such a client/server app and any articles would be much appreciated.

Thanks

Kunal

 

[Windshpere]

This has worked for me in the past.

Put your sql in code and ref. everything their. I have had to generate many tables this way and it works almost every time.

Hope this helps