Continuous Forms

  • Thread starter Thread starter meme
  • Start date Start date
M

meme

I have a form that is based on a query.

The Fields involved are:
ClassID (Class Query)
Class Name (Class Query)
Assignment (Assignment Table)
Max points(Assignment tale)

I want the continuous form to allow update for one class at a time..
Where ClassID .... Like [ Enter Class ID]

This returns only one record... Unless there are no Assignemts for the
class. then it returns no records.

But I want to use the form to update Class assignments.. they will Always
have No record found to start.

How do I fix this?
 
Make the query a left join - Class Query -- Assignment Table
If you do not know how to do this then post the SQL of the query so it can
be edited.
Open the query in design view, click on VIEW - SQL View, highlight all,
copy, and paste in a post.
 
Back
Top