fault finding

[Jen0dorf]

Hi



I Have three tables linked with various queries linked to tables. The end result is a display of essential information in a simpledatasheet format.

One of the fields I've set as a hyperlink to open a form showing all details

Private Sub Surname_Click()
DoCmd.OpenForm "frm_Detail", , , "GraveID = " & Me.GraveID
End Sub

with 39000 records in the database I tested I guess 50 or 60 and from all the searches that drop me into the the basic information field.

A couple of users have come back to me because when on specific records - and it seems on those records only- when they press the button they get a white screen.

Is there any way I can error trap this?

thanks

Ian

[pbaldy]

Might GraveID be Null in those records, or not exist in the source of that form being opened? It sounds like it's opening the form on an empty recordset.

[Jen0dorf]

THanks

You were spot on as your hint took me to inner and outer joins which was causing the error. Time to learn more about nesting inner and outer joins

thanks

Ian

[pbaldy]

Happy to help Ian.