intermittant code??

[Jen0dorf]

Hi



ongoing database which exhibits an intermittant issue

I call a form showing limited details of a record. On that from is a field which has an on click event as below

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

this calls a form showing full details.

However is it intermittant


some times it opens and shows the full details and some times is opens to a greyed out form with just the form name top right

<img src="https://www.accessforums.net/attachment.php?attachmentid=24835&amp;stc=1" attachmentid="24835" alt="" id="vbattach_24835" class="previewthumb">



has anyone any ideas why?



thanks



Ian

[John_sc]

I can not see your image for some reason. In your other post I only see the word Detail in the top left.

Is you database being accesses by more than one person at a time? if someone is accessing it, and someone else then tries to access it at the same time odd things can happen.

[Jen0dorf]

Hi

that was the point - I just explained it badly- I only get the white box with the word detail in the top left.

I re enable the close option and that appears as well. I also re enabled the bottom bar and it shows the search box but in the record count it shows no record count.

really not sure how to trouble shoot this.

thanks

Ian

If when it happens I close the window using the X and then try again it all works as I expect.

It's on my development machine so I am the only one using it.

[John_G]

The problem might be that both forms are trying to display the same record from the same table at the same time, and if the first form locks the record (maybe because you edited a field), then the second one can't open to that record. Not sure if this will work, but try basing the first form on a query, rather than the table itself.