Query result does not allow check boxes to work 1

[houstonbill]

Have 2 tables that make up a query used for a form. They have a relationship based on a ID number. I know my problem has to be with my query, but I am not sure how to fix. If I apply the check boxes to a form based on the Peer Review Table alone, they work fine. But joining my Peer Review table with the main table of Suggestions, causes them not to work. If I change the join, my form is blank since no peer reviews have been summitted. The end result form is reached via a searh form where the user double clicks the SuggID # and goes to the Peer Review Form based on my query. Below is my SQL with hopes that someone can assist:

SELECT tbl_PeerReview.Date, qry_SuggestionTable.SuggestionID, qry_SuggestionTable.BadgeId, qry_SuggestionTable.Idea, tbl_PeerReview.ThumUp, tbl_PeerReview.ThumDown, tbl_PeerReview.Neutral, tbl_PeerReview.BeingImple, tbl_PeerReview.SuccessImple, tbl_PeerReview.Tried, tbl_PeerReview.NoInfo, tbl_PeerReview.Comments
FROM qry_SuggestionTable LEFT JOIN tbl_PeerReview ON qry_SuggestionTable.SuggestionID = tbl_PeerReview.SuggNum;

 

[PHV]

Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[houstonbill]

Thanks for the response.......and reference. This was a reference that I had in my files already but a good opportunity to review. As a newbie, I wasn't quite sure what I was looking for. I did indentfy the type of query I have but was not able to determine how to fix.

What I did thought, was to take the section with check boxes and make that a subform. As a result, everything works fine now. I would still rather have this all on 1 query and let that be the feeder to my form rather than setting up sub-reports. But...it does work now.