I received wonderful help through this forum a few months ago and probably couldn't have gotten this on my own. As our Physicians have started using the database, we discovered a design issue and I need just a little bit more help to make it more functional. I have a form where I'm listing patients and when they double click the Medical Record Number [MRN] it takes them to "Hospital Round Form" and they can fill out their information. The problem is, the MRN is linked to that patient, not the visit, in other words, that patient may have been here several times and his MRN will always be the same. Thus my screen comes up and it may be on the wrong visit, the Dr. may not see the arrows at the bottom to arrow to the other visits. I need to add another filter in the Where claus that states if the [Date of Discharge] is not null, then only show that record. Supposedly, only one of the multiple visits will not have a discharge date, all others will have discharge dates. I'm just not understanding the filter or Where clause and all experiments have failed. Something you can explain in 2 minutes could save me hours. As always, thanks in advance for your help. The following is my code.