Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subform Queries

Status
Not open for further replies.

duns

Programmer
May 22, 2000
13
AU
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top