I have a database program that allows the user to view various reports created by using data from a specific property.
All works well except I am unable to view certain reports from some of the properties. I have assigned each property a property number. The data entered is place in a table where the property number identifies which property that data belongs too. When the query is run for the report it only selects data that has the current property number. This works well for all of the properties except two or three. When I hit the button on my main form to "view report" on the two or three of the properties the view reports screen opens but there is nothing there, and the program goes back to the main form. Is there something wrong in the data? or should I look elsewhere?