OK...everything was working fine, but recently I noticed that when I add new data to my tblObservationStatus it is not updating my report (rptObservationSchedule) which pulls info from multiple tables. I had made some changes to the form, but that doesn't seem to be the problem bc the data shows up in the table, just not the report. My old data is there, but nothing new I add shows up.

If someone thinks they can de-bug it for me I can send the file. I obviously can't see the error bc it looks fine to me. Not sure what I'm missing.:confused:

Your problem is in the query underlying the report. You have an INNER JOIN on the faculty table but not all records have that assigned. You need to change it to an OUTER (RIGHT) JOIN and then all should show up.

Thanks Bob. Can you tell I am a self-taught designer? ;)

That worked on my empty DB, but when I tried to make the changes to the content DB it wouldn't work. I finally figured out that when a Course had an empty location or room number, that course would not show up in my ObservationStatus or ObservationSchedule reports. Why is this so when I do not list either of those fields in those reports? What can I do to allow null values in that table so that it doesn't affect other reports, etc.?