View Single Post
  #20  
Old May 20th, 2010, 07:31 PM posted to microsoft.public.access.forms
BruceM via AccessMonster.com
external usenet poster
 
Posts: 448
Default Setting up tables for grades

I meant to mention that a query based on a table can be used as the Record
Source for a form or report. If tblCourseGrades can be the Record Source, so
can a query based on tblCourseGrades. A query is a SELECT statement with
varying levels of detail, so the correct SELECT statement should work as the
Record Source just as a named query could. You could get a query working as
the Record Source for a form, then open the query in SQL view, copy the text,
and use that instead of the query name as the Record Source. It's all
essentially the same to Access. There may be some performance advantages one
way or the other, but nothing you would be likely to notice in your project.

Gntlhnds wrote:
I don't know how I missed my subform not being bound to tblCourseGrades. I
thought it was, but it had a SELECT statement as its record source. Thanks
for the help. Now it is working the way that it should.

When asking about forms you should always describe the Record Source. Going
back to the table structu

[quoted text clipped - 77 lines]
pick which courses for that student. The combo will show all the courses. Next
to the combo you'ld have a textbox to enter the grade.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201005/1