Form already displayed; can't show modally

[kmlloyd]

I'm not sure what's going on because this was working perfectly yesterday. Below is the code I have for a UserForm. When I click the command button, the message box pops up asking if I want to add another record. When I say NO it works fine...but when I click Yes, I get an error:

Form already displayed; can't show modally

I pasted all of the code here, but the message box info is toward the bottom.

What am I missing? Like I said, this worked perfectly fine yesterday.

Please Login or Register  to view this content.

[pjwhitfield]

Is this code in UserForm1? If so do you need to bother Showing the form again?

[kmlloyd]

This code is in UserForm1.

Yes, I need to show it again if they need to enter more data.

Basically they're entering data into the form and clicking Add. Then a message box asks if they have another client's data they need to enter. If they say Yes, I need the form to show again.

[pjwhitfield]

But the form is already open, ie you havent closed that form in the code therefore its there already. The message you're getting is telling you that you cant already open a form thats already open. So if you want to enter another record then the user is already there. You may need to blank data out etc to start again instead of opening the form again.

[kmlloyd]

I hear you...but then something has changed because yesterday this worked and I don't think I changed anything. Is there any way to fix this code so when they say Yes, it refreshes the form so they can start again and enter more data?

When the user hits Yes, I want the data to blank out, I don't want them to have to do it themselves.

eta: and the form is there, but I have a message box on top of it that says "Do you want to enter another record?" and the only way to get rid of it is to hit Yes or No. When they hit Yes, they get an error. When they hit No, it unloads the form.

[kmlloyd]

Got it. I added the code below. Not sure if it was there before and I deleted it or what...but now it's working the way I want:

Please Login or Register  to view this content.

[pjwhitfield]

In the code for Vba yes, you want to reset the fields to blank, depending on how many and their type this can either be done using a FOR EACH loop eg

Please Login or Register  to view this content.

or by simply saying the likes of

Please Login or Register  to view this content.