If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Continuous Forms
I have a form that is based on a query.
The Fields involved a 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? |
#2
|
|||
|
|||
Continuous Forms
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? meme wrote: I have a form that is based on a query. The Fields involved a 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? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200911/1 |
#3
|
|||
|
|||
Continuous Forms
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. -- Build a little, test a little. "meme" wrote: I have a form that is based on a query. The Fields involved a 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? |
Thread Tools | |
Display Modes | |
|
|