Continuous Forms

[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?

 

[BruceM via AccessMonster.com]

More information is needed. What is the purpose of the database? I know you
want to update class assignments, but that could mean a lot of things. What
is the general structure in terms of tables and relationships? If the form
is based on a query, what is Assignment Table for Assignment and Max Points?
What is the Where ClassID ... expression or code? You say it returns one or
zero records, but under what circumstances? That is, where and how do you
run the code, or how it it used in an expression?

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?

 

[KARL DEWEY]

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.