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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Me.Undo doesn't work, records are added each time i enter the form and exit 0
Open a form with TABS from another form 1
Save subform record, open form, then go to new record 2
Open only matching forms 1
Having Trouble creating a hidden form (A2003) 4
Form Control Focus 2
Repost - Open Form 9
View Records for Editing Only 1

Top