• Subform doesn’t refresh after data entry (97)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Subform doesn’t refresh after data entry (97)

    Author
    Topic
    #360352

    I would like someone to look at my database and help me figure out what I’ve done wrong. I have a form to enter visitor badges (I posted questions about this before, and those questions were answered by people from the bbs – thanks!). It has two buttons on it so that if the company or employee is not already in the list, you can add the company or employee. The buttons call up either the personnel form or company form. You then enter the new information and press the DONE button to return to the main log form, where you scroll a list and pick the new company, which should switch the subform to that company’s information. The problem is that once you press DONE on the personnel form, the company is listed on the main form drop down list, but it doesn’t refresh the subform to enter the badge number.

    Whew. That sure sounds confusing. Much easier to see if you would look at the form and try to enter a new company and employee and then try to go back to the main screen and enter a tag number for that particular company and person.

    Viewing 0 reply threads
    Author
    Replies
    • #542493

      Your message sounds like you’re referring to an attachment. If so, it got lost along the way. Are you also requerying the subform from the AfterUpdate event of the combobox?

      • #542494

        No, I didn’t attach it. It’s too big (162kb). Last time I asked for help, I just emailed the database to anyone who was willing to look at it. I’m not sure how to “requery a subform from the AfterUpdate event of the combobox”… Is this something I do through the properties of the form?

        • #542496

          Is it still too big if you compact and then zip the file? If so, try a decompile first and then compact the database without recompiling first. That usually squeezes out some additional space before you zip the file. [indent]


          Is this something I do through the properties of the form?


          [/indent]No, it’s something you do from code normally. In the AfterUpdate event procedure for your combobox, simply add a line something like Me!subform.requery, where subform is the name of the subform (not necessarily the name of the subform itself) control on your form.

    Viewing 0 reply threads
    Reply To: Subform doesn’t refresh after data entry (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: