Search results

That's what I'm going to do this morning. The top of the form will show all the medical conditions. This will be based on the Med_History table. When the user selects one of the conditions, either by checking an unbound check box (if possible) or by clicking a button, a subform based on the...

Hi RG, If I remove WHERE (((Med_History.Res_ID)='1')) from the query, I do get all the rows from the Med_Conditions table, which is what I want. However, I need to find the medical conditions and the comments that apply to individual residents - so the use of the WHERE condition is essential...

I tried joining the two tables but there is a complication because I need all the rows in the Conditions table, so I Left join it to the History table. This is the SQL. SELECT Med_History.Res_ID, Med_History.Condition_ID, Med_Conditions.Condition...

Thanks, RG, for your concise answer. I was afraid that the solution was "you can't get there from here", but I kept banging my head against the wall on this one because it would have given an elegant solution. This is the problem I was trying to solve. We need a form to record patients'...

Hi, I want to show some text from another table based on the values of the bound fields in each record of a continuous form. I thought it would be easy, but I can't get it to work. I step through the records in the bound recordset and use some of the values to query another table. Then I use...