• Populate ComboBox/Reusing User Form (VB/Word 97)

    Home » Forums » AskWoody support » Productivity software by function » Visual Basic for Applications » Populate ComboBox/Reusing User Form (VB/Word 97)

    Author
    Topic
    #365557

    I have a form (frmApplicant) which I’d like to use over and over. My code currently asks the user if they’d like to add another applicant. If they say yes, it loads frmApplicant. This works fine the first time, but the second time they say yes, the combo boxes are empty and I can’t figure out how to repopulate them.

    Thanks much for any advice. I should think this would be an easy matter…. (sigh) sigh

    Viewing 0 reply threads
    Author
    Replies
    • #564496

      After you hide the form do you unload it? The problem sounds like the form is being hidden but not unloaded. This would mean that when you display the form again, the initialise event is not happening.

      I don’t know why the fields should be empty though. If they were populated when you hid the form, they should still be populated when you unhide it unless you run code to wipe them.

    Viewing 0 reply threads
    Reply To: Populate ComboBox/Reusing User Form (VB/Word 97)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: