Form First Load Empty

S

stevenblanc

Joined
Apr 16, 2010
Messages
3
Reaction score
0
Here's hopefully a quickie.

I open a form linked to the table 'Claims' using a listbox 'lstclaims' to identify the record:

DoCmd.OpenForm "ClaimReview", , , "ClaimNo = " & lstClaims.Column(0)

However, if the form 'ClaimReview' is currently closed then it opens blank. Once its open though it works fine. I can get around the problem by doubleopening the form, ie:

DoCmd.OpenForm "ClaimReview", , , "ClaimNo = " & lstClaims.Column(0)
DoCmd.OpenForm "ClaimReview", , , "ClaimNo = " & lstClaims.Column(0)

But that means everytime i want to change the report i have to open it twice which isn't very neat. What could be causing the problem? any ideas?
 
Back
Top